APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 411: pay_payroll_actions pya,

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,
414: pay_element_types_f ele,
415: pay_input_values_f ipv,

Line 455: pay_payroll_actions pya,

451: p_end_date DATE) IS
452: SELECT /*+ RULE */
453: SUM(NVL(rrv.result_value, 0) * blf.scale) total_dp_hours
454: FROM pay_assignment_actions asa,
455: pay_payroll_actions pya,
456: pay_run_results rrs,
457: pay_run_result_values rrv,
458: pay_element_types_f ele,
459: pay_input_values_f ipv,

Line 495: pay_payroll_actions pya,

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,
498: pay_element_types_f ele,
499: pay_input_values_f ipv,

Line 539: pay_payroll_actions pya,

535: p_end_date DATE) IS
536: SELECT /*+ RULE */
537: SUM(NVL(rrv.result_value, 0) * blf.scale) total_de_hours
538: FROM pay_assignment_actions asa,
539: pay_payroll_actions pya,
540: pay_run_results rrs,
541: pay_run_result_values rrv,
542: pay_element_types_f ele,
543: pay_input_values_f ipv,

Line 687: pay_payroll_actions pya,

683: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
684: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
685: 55,NVL(rrv.result_value, 0)*blf.scale,0)),0)
686: FROM pay_assignment_actions asa,
687: pay_payroll_actions pya,
688: pay_run_results rrs,
689: pay_run_result_values rrv,
690: pay_element_types_f ele,
691: pay_element_classifications elc,

Line 843: pay_payroll_actions pya,

839: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
840: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
841: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0)
842: FROM pay_assignment_actions asa,
843: pay_payroll_actions pya,
844: pay_run_results rrs,
845: pay_run_result_values rrv,
846: pay_element_types_f ele,
847: pay_element_classifications elc,

Line 999: pay_payroll_actions pya,

995: 52, NVL(rrv.result_value, 0)*blf.scale,0)),0),
996: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
997: 53, NVL(rrv.result_value, 0)*blf.scale,0)),0)
998: FROM pay_assignment_actions asa,
999: pay_payroll_actions pya,
1000: pay_run_results rrs,
1001: pay_run_result_values rrv,
1002: pay_element_types_f ele,
1003: pay_element_classifications elc,

Line 1137: pay_payroll_actions ppa,

1133: ppa.payroll_action_id,
1134: ppa.effective_date,
1135: ppa.start_date
1136: from
1137: pay_payroll_actions ppa,
1138: pay_assignment_actions paa
1139: where
1140: paa.assignment_id = p_assignment_id and
1141: paa.tax_unit_id = p_gre and

Line 1166: pay_payroll_actions ppa,

1162: p_pay_period_end_date date) is
1163: select
1164: 'X'
1165: from
1166: pay_payroll_actions ppa,
1167: pay_assignment_actions paa
1168: where
1169: ppa.action_status = 'C' and
1170: ppa.action_type in ('Q','R') and

Line 1239: pay_payroll_actions ppa

1235: select ppa.date_earned
1236: from
1237: pay_run_results prr,
1238: pay_assignment_actions paa,
1239: pay_payroll_actions ppa
1240: where ppa.payroll_action_id = paa.payroll_action_id
1241: and ppa.date_earned between p_start_date
1242: and p_end_date
1243: and prr.assignment_action_id = paa.assignment_action_id

Line 1252: pay_payroll_actions ppa

1248: p_end_date date) is
1249: select ppa.date_earned
1250: from
1251: pay_assignment_actions paa,
1252: pay_payroll_actions ppa
1253: where ppa.payroll_action_id = paa.payroll_action_id
1254: and ppa.date_earned between p_start_date
1255: and p_end_date
1256: and paa.assignment_action_id = p_asg_action_id;