DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 3368: pay_ca_emp_prov_tax_info_f pcefti

3364: cp_person_id in number,
3365: cp_effective_date in date ) is
3366: select qpp_exempt_flag
3367: from per_all_assignments_f paaf,
3368: pay_ca_emp_prov_tax_info_f pcefti
3369: where paaf.person_id = cp_person_id
3370: and to_char(cp_effective_date,'YYYY') between
3371: to_char(paaf.effective_start_date,'YYYY') and
3372: to_char(paaf.effective_end_date, 'YYYY' )

Line 3388: pay_ca_emp_prov_tax_info_f pcefti

3384: cp_person_id in number,
3385: cp_effective_date in date ) is
3386: select ppip_exempt_flag
3387: from per_all_assignments_f paaf,
3388: pay_ca_emp_prov_tax_info_f pcefti
3389: where paaf.person_id = cp_person_id
3390: and to_char(cp_effective_date,'YYYY') between
3391: to_char(paaf.effective_start_date,'YYYY') and
3392: to_char(paaf.effective_end_date, 'YYYY' )