APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 410: pay_assignment_actions asa,

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

Line 454: FROM pay_assignment_actions asa,

450: p_start_date DATE,
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,

Line 494: pay_assignment_actions asa,

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

Line 538: FROM pay_assignment_actions asa,

534: p_start_date DATE,
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,

Line 686: FROM pay_assignment_actions asa,

682: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
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,

Line 842: FROM pay_assignment_actions asa,

838: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
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,

Line 998: FROM pay_assignment_actions asa,

994: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
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,

Line 1138: pay_assignment_actions paa

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
1142: ppa.payroll_id = p_payroll_id and

Line 1167: pay_assignment_actions paa

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
1171: ppa.date_earned between p_pay_period_start_date and

Line 1238: pay_assignment_actions paa,

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
1242: and p_end_date

Line 1251: pay_assignment_actions paa,

1247: p_start_date date,
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