APPS.PAY_GB_RTI dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 2102: from hr_assignment_set_amendments hasa

2098: and (l_payroll_id IS NULL
2099: or
2100: l_payroll_id = pay.payroll_id)
2101: and not exists (select 1
2102: from hr_assignment_set_amendments hasa
2103: where hasa.assignment_set_id = l_assignment_set
2104: and hasa.assignment_id = asg.assignment_id
2105: and hasa.include_or_exclude = 'E')
2106: and serv.date_start <= l_effective_date

Line 2115: from hr_assignment_set_amendments

2111:
2112: cursor csr_exc_inc is
2113: -- Assuming Only one type of include_or_exclude will be there for an assignment set
2114: select nvl(include_or_exclude,'I')
2115: from hr_assignment_set_amendments
2116: where assignment_set_id = l_assignment_set;
2117:
2118: l_prev_person number:=0;
2119: l_flag varchar2(1) :='Y';