APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 233: from pay_ca_emp_prov_tax_info_f.

229: per_all_assignments_f table check
230: from the select statement in the
231: procedure eoy_archive_data to fetch
232: the CPP/QPP exempt flag
233: from pay_ca_emp_prov_tax_info_f.
234: 25-Jul-2006 ssmukher 115.81 Made modification in the
235: eoy_archive_data procedure to
236: incorporate the PPIP tax.
237: 28-AUG-2006 pganguly 115.82 Fixed bug# 4025900. Changed the code

Line 3702: FROM pay_ca_emp_prov_tax_info_f target

3698: SELECT decode(target.QPP_EXEMPT_FLAG,'Y','X',NULL),
3699: decode(target.PPIP_EXEMPT_FLAG,'Y','X',NULL)
3700: INTO lv_qpp_exempt_flag,
3701: l_ppip_exempt_flag
3702: FROM pay_ca_emp_prov_tax_info_f target
3703: WHERE target.assignment_id = l_each_asgid
3704: and target.province_code = 'QC'
3705: and lv_actual_date/*p_effective_date */ between target.effective_start_date
3706: and target.effective_end_date;