APPS.PAY_GB_EOY dependencies on PAY_GB_YEAR_END_ASSIGNMENTS

Line 153: FROM pay_gb_year_end_assignments b

149: NVL(cp_tax_dist_ref,a.tax_district_reference)
150: AND a.business_group_id = NVL(cp_business_group_id,
151: a.business_group_id)
152: AND EXISTS (SELECT '1'
153: FROM pay_gb_year_end_assignments b
154: WHERE a.payroll_id = b.payroll_id)
155: ORDER BY a.permit_number,a.payroll_id;
156: --
157: CURSOR emps_cur(cp_payroll_id NUMBER) IS

Line 190: FROM pay_gb_year_end_assignments a

186: ,NVL(UPPER(a.pensioner_indicator),' ')
187: ,NVL(UPPER(a.director_indicator),' ')
188: ,a.assignment_id
189: ,a.effective_end_date
190: FROM pay_gb_year_end_assignments a
191: WHERE a.payroll_id = cp_payroll_id
192: ORDER BY a.last_name, a.first_name;
193: --
194: CURSOR emp_values(cp_assignment_id NUMBER

Line 217: FROM pay_gb_year_end_assignments b

213: FROM pay_gb_year_end_values a
214: WHERE a.ni_category_code IN ('D','E')
215: AND (a.assignment_id,a.effective_end_date) IN
216: (SELECT b.assignment_id,b.effective_end_date
217: FROM pay_gb_year_end_assignments b
218: ,pay_gb_year_end_payrolls c
219: WHERE c.permit_number = NVL(cp_permit_no, c.permit_number)
220: AND c.tax_reference_number =
221: NVL(cp_tax_ref_no,c.tax_reference_number)

Line 802: l_assignment_id pay_gb_year_end_assignments.assignment_id%TYPE;

798: l_week_53_indicator VARCHAR2(1);
799: l_taxable_pay NUMBER(9);
800: l_pension_indicator VARCHAR2(1);
801: l_director_indicator VARCHAR2(1);
802: l_assignment_id pay_gb_year_end_assignments.assignment_id%TYPE;
803: l_effective_date DATE;
804: --
805: -- General purpose variables
806: l_index NUMBER(3) :=0; -- General purpose loop counter