DBA Data[Home] [Help]

APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_RUN_RESULTS

Line 412: pay_run_results rrs,

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,
416: pay_balance_feeds_f blf,

Line 456: pay_run_results rrs,

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,
460: pay_balance_feeds_f blf,

Line 496: pay_run_results rrs,

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,
500: pay_balance_feeds_f blf,

Line 540: pay_run_results rrs,

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,
544: pay_balance_feeds_f blf,

Line 688: pay_run_results rrs,

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,
692: pay_input_values_f ipv,

Line 844: pay_run_results rrs,

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,
848: pay_input_values_f ipv,

Line 1000: pay_run_results rrs,

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,
1004: pay_input_values_f ipv,

Line 1237: pay_run_results prr,

1233: p_start_date date,
1234: p_end_date date) is
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