DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 3459: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti

3455: cursor cur_cpp_block ( cp_bg_id in number,
3456: cp_person_id in number,
3457: cp_effective_date in date ) is
3458: select cpp_qpp_exempt_flag
3459: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3460: where paaf.person_id = cp_person_id
3461: and to_char(cp_effective_date,'YYYY') between
3462: to_char(paaf.effective_start_date,'YYYY') and
3463: to_char(paaf.effective_end_date, 'YYYY' )

Line 3478: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti

3474: cursor cur_ei_block ( cp_bg_id in number,
3475: cp_person_id in number,
3476: cp_effective_date in date ) is
3477: select ei_exempt_flag
3478: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3479: where paaf.person_id = cp_person_id
3480: and to_char(cp_effective_date,'YYYY') between
3481: to_char(paaf.effective_start_date,'YYYY') and
3482: to_char(paaf.effective_end_date, 'YYYY' )