APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 2259: from pay_ca_emp_fed_tax_info_f pca

2255: /* This cursor fetches the Status Indian flag for a assignment */
2256: CURSOR c_get_status_indian(cp_assign number,
2257: cp_effec_date date) IS
2258: select ca_tax_information1
2259: from pay_ca_emp_fed_tax_info_f pca
2260: where pca.assignment_id = cp_assign
2261: and cp_effec_date between pca.effective_start_date and
2262: pca.effective_end_date;
2263: begin

Line 3101: FROM pay_ca_emp_fed_tax_info_f target

3097: SELECT decode(target.CPP_QPP_EXEMPT_FLAG,'Y','X',NULL),
3098: decode(target.EI_EXEMPT_FLAG,'Y','X',NULL)
3099: INTO l_cpp_exempt_flag,
3100: l_ei_exempt_flag
3101: FROM pay_ca_emp_fed_tax_info_f target
3102: WHERE target.assignment_id = l_asgid
3103: and lv_actual_date/*p_effective_date*/ between target.effective_start_date
3104: and target.effective_end_date;
3105: