DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_REPORT dependencies on HR_LOOKUPS

Line 167: ,hr_lookups hrl

163: ,c_legislation_code VARCHAR2) IS
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

Line 202: ,hr_lookups hrl

198: ,c_assignment_set_id NUMBER ) IS
199: SELECT 'Y'
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

Line 390: ,hr_lookups hrl

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')
392: AND ptoa.object_id = paa.assignment_id
393: AND paa.payroll_action_id = ppa.payroll_action_id
394: AND ppa.effective_Date BETWEEN c_start_date