DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 139: ,hr_assignment_set_amendments hasa

135: CURSOR csr_assignment_filter(p_assignment_set_id NUMBER
136: ,p_assignment_id NUMBER) IS
137: SELECT hasa.INCLUDE_OR_EXCLUDE
138: FROM hr_assignment_sets has
139: ,hr_assignment_set_amendments hasa
140: WHERE has.assignment_set_id = hasa.assignment_set_id
141: AND has.assignment_set_id = p_assignment_set_id
142: --AND hasa.INCLUDE_OR_EXCLUDE = 'I'
143: AND hasa.assignment_id = p_assignment_id;