Fetch employee's work/personal and manager's email address? SELECT GL.person_id KEY, 'Template Name' TEMPLATE, 'en-US' LOCALE, 'RTF' template_format, 'PDF' output_format, 'EMAIL' DEL_CHANNEL, 'Document Name' OUTPUT_NAME, GL.work_email ||';'|| GL.Personal_Email || PARAMETER1, 'noreply@company.com' PARAMETER3, 'Email Body ' AS PARAMETER5, 'true' PARAMETER6 FROM ( SELECT papf.person_id, haou_lemp.name legal_employer, hla.address_line_1 work_address_line_1, hla.address_line_2 work_address_line_2, hla.address_line_3 work_address_line_3, hla.address_line_4 work_address_line_4, hla.region_2 work_state, hla.town_or_city work_town_or_city, hla.postal_code work_postal_code, hla.country work_country, papf.person_number, (ppnf.first_name || ' ' || ppnf.last_name) Full_Name, ppos.actual_termination_date Termination_Date, ppos.NOTIFI...
Posts
Showing posts with the label Queries1