APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 2548: from pay_ca_emp_fed_tax_info_f pca

2544: /* This cursor fetches the Status Indian flag for a assignment */
2545: CURSOR c_get_status_indian(cp_assign number,
2546: cp_effec_date date) IS
2547: select ca_tax_information1
2548: from pay_ca_emp_fed_tax_info_f pca
2549: where pca.assignment_id = cp_assign
2550: and cp_effec_date between pca.effective_start_date and
2551: pca.effective_end_date;
2552:

Line 3656: FROM pay_ca_emp_fed_tax_info_f target

3652: SELECT decode(target.CPP_QPP_EXEMPT_FLAG,'Y','X',NULL),
3653: decode(target.EI_EXEMPT_FLAG,'Y','X',NULL)
3654: INTO l_cpp_exempt_flag,
3655: l_ei_exempt_flag
3656: FROM pay_ca_emp_fed_tax_info_f target
3657: WHERE target.assignment_id = l_each_asgid
3658: and lv_actual_date/*p_effective_date*/ between target.effective_start_date
3659: and target.effective_end_date;
3660: