DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_REPORT dependencies on HR_LOOKUPS

Line 171: ,hr_lookups hrl

167: ,c_legislation_code VARCHAR2) IS
168: SELECT 'Y'
169: FROM pay_assignment_actions paa
170: ,pay_payroll_actions ppa
171: ,hr_lookups hrl
172: ,pay_action_information pai
173: ,per_time_periods ptp
174: WHERE paa.assignment_id = c_assignment_id
175: AND paa.payroll_action_id = ppa.payroll_action_id

Line 208: ,hr_lookups hrl

204: ,c_assignment_set_id NUMBER ) IS
205: SELECT 'Y'
206: FROM pay_assignment_actions paa
207: ,pay_payroll_actions ppa
208: ,hr_lookups hrl
209: ,hr_assignment_set_amendments hasa
210: ,pay_action_information pai
211: ,per_time_periods ptp
212: WHERE paa.assignment_id = c_assignment_id

Line 440: ,hr_lookups hrl

436: FROM pay_temp_object_actions ptoa
437: ,pay_action_information pai
438: ,pay_assignment_Actions paa
439: ,pay_payroll_actions ppa
440: ,hr_lookups hrl
441: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
442: AND ptoa.object_id = paa.assignment_id
443: AND paa.payroll_action_id = ppa.payroll_action_id
444: AND ppa.effective_Date BETWEEN c_start_date