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 3143: FROM pay_ca_emp_prov_tax_info_f target

3139: SELECT decode(target.QPP_EXEMPT_FLAG,'Y','X',NULL),
3140: decode(target.PPIP_EXEMPT_FLAG,'Y','X',NULL)
3141: INTO lv_qpp_exempt_flag,
3142: l_ppip_exempt_flag
3143: FROM pay_ca_emp_prov_tax_info_f target
3144: WHERE target.assignment_id = l_asgid
3145: and target.province_code = 'QC'
3146: and lv_actual_date/*p_effective_date */ between target.effective_start_date
3147: and target.effective_end_date;