DBA Data[Home] [Help]

APPS.HR_NONRUN_ASACT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 2333: from hr_assignment_set_amendments hasa

2329: WHERE aset.assignment_set_id = pasgsetid
2330: and nvl(aset.payroll_id,ppayrollid) = ppayrollid
2331: and (not exists
2332: (select 1
2333: from hr_assignment_set_amendments hasa
2334: where hasa.assignment_set_id = aset.assignment_set_id
2335: and hasa.include_or_exclude = 'I')
2336: or exists
2337: (select 1

Line 2338: from hr_assignment_set_amendments hasa

2334: where hasa.assignment_set_id = aset.assignment_set_id
2335: and hasa.include_or_exclude = 'I')
2336: or exists
2337: (select 1
2338: from hr_assignment_set_amendments hasa
2339: where hasa.assignment_set_id = aset.assignment_set_id
2340: and hasa.assignment_id = pasgid
2341: and hasa.include_or_exclude = 'I'))
2342: and not exists

Line 2344: from hr_assignment_set_amendments hasa

2340: and hasa.assignment_id = pasgid
2341: and hasa.include_or_exclude = 'I'))
2342: and not exists
2343: (select 1
2344: from hr_assignment_set_amendments hasa
2345: where hasa.assignment_set_id = aset.assignment_set_id
2346: and hasa.assignment_id = pasgid
2347: and hasa.include_or_exclude = 'E')
2348: -- Ensure there exists a voided check for this payment.