APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 908: FROM pay_payroll_actions

904: WHERE hasa.assignment_set_id = p_assignment_set_id;
905: --
906: CURSOR get_year(c_payroll_action_id NUMBER) IS
907: SELECT TO_CHAR(effective_date,'RRRR')
908: FROM pay_payroll_actions
909: WHERE payroll_action_id = c_payroll_action_id;
910: --
911: l_proc_name VARCHAR2(100);
912: l_xml CLOB;