[Home] [Help]
74: ,nvl(ettl.reporting_name,ettl.element_name) COL02
75: ,to_char(sum(fnd_number.canonical_to_number(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
76: ,decode(count(*),1,''1'',''2'') COL17 -- destination indicator
77: ,decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
78: From pay_assignment_actions aa
79: ,pay_run_results rr
80: ,pay_run_result_values rrv
81: ,pay_input_values_f iv
82: ,pay_input_values_f_tl ivtl
170: ,ptp.period_num as COL16
171: From per_all_people_f peo
172: ,per_all_assignments_f asg
173: ,per_jobs_vl job
174: ,pay_assignment_actions paa
175: ,per_assignment_extra_info pae
176: ,per_periods_of_service pps
177: ,pay_payroll_actions ppa
178: ,per_time_periods ptp
275: ,fnd_date.date_to_displaydate(ptp.start_date) as COL04 -- Period Start Date
276: ,fnd_date.date_to_displaydate(ptp.end_date) as COL05 -- Period End Date
277: From per_time_periods ptp
278: ,pay_payroll_actions ppa
279: ,pay_assignment_actions paa
280: ,per_time_period_types ptt
281: Where paa.assignment_action_id = ''' || p_assignment_action_id || ''' and
282: paa.payroll_action_id = ppa.payroll_action_id and
283: ptp.payroll_id = ppa.payroll_id AND '
516: ,nvl(org.org_information7,pbt.balance_name) as display_name
517: ,pbd.dimension_name as balance_suffix
518: From pay_balance_types pbt
519: ,pay_balance_dimensions pbd
520: ,pay_assignment_actions paa
521: ,pay_payroll_actions ppa
522: ,per_all_assignments_f asg
523: ,hr_organization_information org
524: Where paa.assignment_action_id = p_assignment_action_id and
910: ,pay_personal_payment_methods_f pppmf
911: ,pay_org_payment_methods_f popmf
912: ,pay_external_accounts pea
913: ,pay_za_branch_cdv_details cdv
914: ,pay_assignment_actions paa
915: ,pay_payroll_actions ppa
916: ,pay_payment_types_tl ppt
917: ,pay_action_interlocks pai
918: Where (pai.locked_action_id = :assignment_action_id or pai.locking_action_id = :assignment_action_id) and