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 387: ,pay_action_information pai

383: ,c_cs_token VARCHAR2
384: ,c_legislation_code VARCHAR2) IS
385: SELECT pai.action_context_id
386: FROM pay_temp_object_actions ptoa
387: ,pay_action_information pai
388: ,pay_assignment_Actions paa
389: ,pay_payroll_actions ppa
390: ,hr_lookups hrl
391: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')