DBA Data[Home] [Help]

APPS.PAY_ADHOC_UTILS_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 764: from hr_assignment_set_amendments hasa

760: and nvl(aset.payroll_id,c_payroll_id) = c_payroll_id
761: and aset.business_group_id = c_business_group_id
762: and (not exists
763: (select 1
764: from hr_assignment_set_amendments hasa
765: where hasa.assignment_set_id = aset.assignment_set_id
766: and hasa.include_or_exclude = 'I')
767: or exists
768: (select 1

Line 769: from hr_assignment_set_amendments hasa

765: where hasa.assignment_set_id = aset.assignment_set_id
766: and hasa.include_or_exclude = 'I')
767: or exists
768: (select 1
769: from hr_assignment_set_amendments hasa
770: where hasa.assignment_set_id = aset.assignment_set_id
771: and hasa.assignment_id = c_assignment_id
772: and hasa.include_or_exclude = 'I'))
773: and not exists

Line 775: from hr_assignment_set_amendments hasa

771: and hasa.assignment_id = c_assignment_id
772: and hasa.include_or_exclude = 'I'))
773: and not exists
774: (select 1
775: from hr_assignment_set_amendments hasa
776: where hasa.assignment_set_id = aset.assignment_set_id
777: and hasa.assignment_id = c_assignment_id
778: and hasa.include_or_exclude = 'E') ;
779: --