DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_REPORT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 203: ,hr_assignment_set_amendments hasa

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
207: AND paa.payroll_action_id = ppa.payroll_action_id

Line 235: FROM hr_assignment_set_amendments

231: --
232: CURSOR csr_inc_exc(c_assignment_set_id NUMBER
233: ,c_assignment_id NUMBER) IS
234: SELECT include_or_exclude
235: FROM hr_assignment_set_amendments
236: WHERE assignment_set_id = c_assignment_set_id
237: AND assignment_id = nvl(c_assignment_id,assignment_id);
238: --
239: BEGIN