APPS.PAY_GB_RTI_EAS dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 2738: from hr_assignment_set_amendments hasa

2734: and (l_payroll_id IS NULL
2735: or
2736: l_payroll_id = pay.payroll_id)
2737: and not exists (select 1
2738: from hr_assignment_set_amendments hasa
2739: where hasa.assignment_set_id = l_assignment_set
2740: and hasa.assignment_id = asg.assignment_id
2741: and hasa.include_or_exclude = 'E')
2742: and serv.date_start <= l_effective_date

Line 2751: from hr_assignment_set_amendments

2747:
2748: cursor csr_exc_inc is
2749: -- Assuming Only one type of include_or_exclude will be there for an assignment set
2750: select nvl(include_or_exclude,'I')
2751: from hr_assignment_set_amendments
2752: where assignment_set_id = l_assignment_set;
2753:
2754: l_prev_person number:=0;
2755: l_flag varchar2(1) :='Y';