APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 409: FROM pay_ca_emp_fed_tax_info_f fti,

405: p_start_date DATE,
406: p_end_date DATE) IS
407: SELECT /*+ RULE */
408: SUM(NVL(rrv.result_value, 0) * blf.scale) total_dp_hours
409: FROM pay_ca_emp_fed_tax_info_f fti,
410: pay_assignment_actions asa,
411: pay_payroll_actions pya,
412: pay_run_results rrs,
413: pay_run_result_values rrv,

Line 493: FROM pay_ca_emp_fed_tax_info_f fti,

489: p_start_date DATE,
490: p_end_date DATE) IS
491: SELECT /*+ RULE */
492: SUM(NVL(rrv.result_value, 0) * blf.scale) total_de_hours
493: FROM pay_ca_emp_fed_tax_info_f fti,
494: pay_assignment_actions asa,
495: pay_payroll_actions pya,
496: pay_run_results rrs,
497: pay_run_result_values rrv,

Line 1273: pay_ca_emp_fed_tax_info_f

1269: p_ftr_end_date DATE) IS
1270: SELECT
1271: 'X'
1272: FROM
1273: pay_ca_emp_fed_tax_info_f
1274: WHERE
1275: assignment_id = p_assignment_id AND
1276: effective_start_date <= p_ftr_end_date AND
1277: effective_end_date >= p_ftr_start_date;