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 395: ,hr_lookups hrl

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')
397: AND ptoa.object_id = paa.assignment_id
398: AND paa.payroll_action_id = ppa.payroll_action_id
399: AND ppa.effective_Date BETWEEN c_start_date