DBA Data[Home] [Help]

APPS.PAY_GB_EOY dependencies on PAY_GB_YEAR_END_PAYROLLS

Line 144: FROM pay_gb_year_end_payrolls a

140: ,UPPER(NVL(a.econ,'?'))
141: ,nvl(ssp_recovered,0)
142: ,nvl(smp_recovered,0)
143: ,nvl(smp_compensation,0)
144: FROM pay_gb_year_end_payrolls a
145: WHERE a.permit_number = NVL(cp_permit_no,a.permit_number)
146: AND a.tax_reference_number =
147: NVL(cp_tax_ref_no,a.tax_reference_number)
148: AND a.tax_district_reference =

Line 218: ,pay_gb_year_end_payrolls c

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)
222: AND c.tax_district_reference =