DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_REPORT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 209: ,hr_assignment_set_amendments hasa

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

Line 241: FROM hr_assignment_set_amendments

237: --
238: CURSOR csr_inc_exc(c_assignment_set_id NUMBER
239: ,c_assignment_id NUMBER) IS
240: SELECT include_or_exclude
241: FROM hr_assignment_set_amendments
242: WHERE assignment_set_id = c_assignment_set_id
243: AND assignment_id = nvl(c_assignment_id,assignment_id);
244: --
245: BEGIN