DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_REPORT dependencies on PAY_ACTION_INFORMATION

Line 168: ,pay_action_information pai

164: SELECT 'Y'
165: FROM pay_assignment_actions paa
166: ,pay_payroll_actions ppa
167: ,hr_lookups hrl
168: ,pay_action_information pai
169: ,per_time_periods ptp
170: WHERE paa.assignment_id = c_assignment_id
171: AND paa.payroll_action_id = ppa.payroll_action_id
172: AND paa.source_action_id IS NULL

Line 204: ,pay_action_information pai

200: FROM pay_assignment_actions paa
201: ,pay_payroll_actions ppa
202: ,hr_lookups hrl
203: ,hr_assignment_set_amendments hasa
204: ,pay_action_information pai
205: ,per_time_periods ptp
206: WHERE paa.assignment_id = c_assignment_id
207: AND paa.payroll_action_id = ppa.payroll_action_id
208: AND paa.source_action_id IS NULL

Line 392: ,pay_action_information pai

388: ,c_cs_token VARCHAR2
389: ,c_legislation_code VARCHAR2) IS
390: SELECT pai.action_context_id
391: FROM pay_temp_object_actions ptoa
392: ,pay_action_information pai
393: ,pay_assignment_Actions paa
394: ,pay_payroll_actions ppa
395: ,hr_lookups hrl
396: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')