DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 1339: FROM hr_assignment_set_amendments hasa

1335: ,p_xml OUT NOCOPY CLOB) IS
1336: --
1337: CURSOR csr_inc_exc(p_assignment_set_id NUMBER) IS
1338: SELECT include_or_exclude
1339: FROM hr_assignment_set_amendments hasa
1340: WHERE hasa.assignment_set_id = p_assignment_set_id;
1341: --
1342: CURSOR get_year(c_payroll_action_id NUMBER) IS
1343: SELECT TO_CHAR(effective_date,'RRRR')