[Home] [Help]
407: SELECT /*+ leading(asa,pya,ele) use_merge(ele) */
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,
451: p_end_date DATE) IS
452: SELECT /*+ leading(asa,pya,ele) use_merge(ele) */
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,
491: SELECT /*+ leading(asa,pya,ele) use_merge(ele) */
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,
535: p_end_date DATE) IS
536: SELECT /*+ leading(asa,pya,ele) use_merge(ele) */
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,
684: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
685: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
686: 55,NVL(rrv.result_value, 0)*blf.scale,0)),0)
687: FROM pay_assignment_actions asa,
688: pay_payroll_actions pya,
689: pay_run_results rrs,
690: pay_run_result_values rrv,
691: pay_element_types_f ele,
692: pay_element_classifications elc,
840: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
841: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
842: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0)
843: FROM pay_assignment_actions asa,
844: pay_payroll_actions pya,
845: pay_run_results rrs,
846: pay_run_result_values rrv,
847: pay_element_types_f ele,
848: pay_element_classifications elc,
1000: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
1001: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1002: 55,NVL(rrv.result_value, 0)*blf.scale,0)),0)
1003: FROM pay_assignment_actions asa,
1004: pay_payroll_actions pya,
1005: pay_run_results rrs,
1006: pay_run_result_values rrv,
1007: pay_element_types_f ele,
1008: pay_element_classifications elc,
1155: 52, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1156: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1157: 53, NVL(rrv.result_value, 0)*blf.scale,0)),0)
1158: FROM pay_assignment_actions asa,
1159: pay_payroll_actions pya,
1160: pay_run_results rrs,
1161: pay_run_result_values rrv,
1162: pay_element_types_f ele,
1163: pay_element_classifications elc,
1293: ppa.payroll_action_id,
1294: ppa.effective_date,
1295: ppa.start_date
1296: from
1297: pay_payroll_actions ppa,
1298: pay_assignment_actions paa
1299: where
1300: paa.assignment_id = p_assignment_id and
1301: paa.tax_unit_id = p_gre and
1322: p_pay_period_end_date date) is
1323: select
1324: 'X'
1325: from
1326: pay_payroll_actions ppa,
1327: pay_assignment_actions paa
1328: where
1329: ppa.action_status = 'C' and
1330: ppa.action_type in ('Q','R') and
1422: select ppa.date_earned
1423: from
1424: pay_run_results prr,
1425: pay_assignment_actions paa,
1426: pay_payroll_actions ppa
1427: where ppa.payroll_action_id = paa.payroll_action_id
1428: and ppa.date_earned between p_start_date
1429: and p_end_date
1430: and prr.assignment_action_id = paa.assignment_action_id
1435: p_end_date date) is
1436: select ppa.date_earned
1437: from
1438: pay_assignment_actions paa,
1439: pay_payroll_actions ppa
1440: where ppa.payroll_action_id = paa.payroll_action_id
1441: and ppa.date_earned between p_start_date
1442: and p_end_date
1443: and paa.assignment_action_id = p_asg_action_id;