DBA Data[Home] [Help]

APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 300: FROM hr_assignment_set_amendments hasa

296: AND NVL(paa.payroll_id,0) = NVL(has.payroll_id,NVL(paa.payroll_id,0))
297: AND NOT EXISTS
298: (
299: SELECT 1
300: FROM hr_assignment_set_amendments hasa
301: WHERE hasa.assignment_set_id = c_assignment_set_id
302: AND hasa.assignment_id = c_assignment_id
303: AND hasa.include_or_exclude = 'E'
304: )

Line 308: FROM hr_assignment_set_amendments hasa

304: )
305: AND NOT EXISTS
306: (
307: SELECT 1
308: FROM hr_assignment_set_amendments hasa
309: WHERE hasa.assignment_set_id = c_assignment_set_id
310: AND hasa.assignment_id <> c_assignment_id
311: AND hasa.include_or_exclude = 'I'
312: AND NOT EXISTS

Line 315: FROM hr_assignment_set_amendments hasa

311: AND hasa.include_or_exclude = 'I'
312: AND NOT EXISTS
313: (
314: SELECT 1
315: FROM hr_assignment_set_amendments hasa
316: WHERE hasa.assignment_set_id = c_assignment_set_id
317: AND hasa.assignment_id = c_assignment_id
318: AND hasa.include_or_exclude = 'I'
319: )