977:
978: PROCEDURE get_ni_bal_paye_aggr_for_asg(
979: p_asg_id IN NUMBER,
980: l_last_asg_action_id IN NUMBER,
981: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
982: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
983: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
984: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
985: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
978: PROCEDURE get_ni_bal_paye_aggr_for_asg(
979: p_asg_id IN NUMBER,
980: l_last_asg_action_id IN NUMBER,
981: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
982: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
983: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
984: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
985: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
986: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
979: p_asg_id IN NUMBER,
980: l_last_asg_action_id IN NUMBER,
981: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
982: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
983: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
984: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
985: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
986: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
987: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
980: l_last_asg_action_id IN NUMBER,
981: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
982: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
983: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
984: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
985: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
986: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
987: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
988: IS
981: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
982: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
983: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
984: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
985: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
986: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
987: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
988: IS
989: -- local variables to store NI total and able balances
982: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
983: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
984: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
985: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
986: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
987: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
988: IS
989: -- local variables to store NI total and able balances
990: l_nia_tot NUMBER(15,2) :=0;
983: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
984: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
985: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
986: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
987: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
988: IS
989: -- local variables to store NI total and able balances
990: l_nia_tot NUMBER(15,2) :=0;
991: l_nia_able NUMBER(15,2) :=0;
1304: END get_ni_bal_paye_aggr_for_asg;
1305:
1306: PROCEDURE get_ni_only_bal_rti_rpt(
1307: l_last_asg_action_id IN NUMBER,
1308: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1309: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1310: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1311: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1312: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1305:
1306: PROCEDURE get_ni_only_bal_rti_rpt(
1307: l_last_asg_action_id IN NUMBER,
1308: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1309: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1310: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1311: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1312: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1313: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1306: PROCEDURE get_ni_only_bal_rti_rpt(
1307: l_last_asg_action_id IN NUMBER,
1308: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1309: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1310: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1311: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1312: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1313: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1314: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1307: l_last_asg_action_id IN NUMBER,
1308: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1309: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1310: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1311: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1312: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1313: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1314: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1315: IS
1308: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1309: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1310: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1311: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1312: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1313: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1314: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1315: IS
1316: -- local variables to store NI total and able balances
1309: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1310: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1311: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1312: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1313: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1314: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1315: IS
1316: -- local variables to store NI total and able balances
1317: l_nia_tot NUMBER(15,2) :=0;
1310: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1311: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1312: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1313: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1314: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1315: IS
1316: -- local variables to store NI total and able balances
1317: l_nia_tot NUMBER(15,2) :=0;
1318: l_nia_able NUMBER(15,2) :=0;
1632: */
1633:
1634: PROCEDURE get_ni_balances_for_asg(
1635: l_last_asg_action_id IN NUMBER,
1636: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1637: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1638: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1639: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1640: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1633:
1634: PROCEDURE get_ni_balances_for_asg(
1635: l_last_asg_action_id IN NUMBER,
1636: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1637: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1638: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1639: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1640: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1641: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1634: PROCEDURE get_ni_balances_for_asg(
1635: l_last_asg_action_id IN NUMBER,
1636: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1637: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1638: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1639: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1640: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1641: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1642: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1635: l_last_asg_action_id IN NUMBER,
1636: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1637: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1638: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1639: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1640: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1641: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1642: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1643: IS
1636: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1637: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1638: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1639: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1640: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1641: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1642: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1643: IS
1644: -- local variables to store NI total and able balances
1637: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1638: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1639: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1640: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1641: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1642: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1643: IS
1644: -- local variables to store NI total and able balances
1645: l_nia_tot NUMBER(15,2) :=0;
1638: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1639: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1640: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1641: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
1642: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
1643: IS
1644: -- local variables to store NI total and able balances
1645: l_nia_tot NUMBER(15,2) :=0;
1646: l_nia_able NUMBER(15,2) :=0;
2295:
2296: -- For aggregated assginments
2297: PROCEDURE get_ni_only_agg_bal_for_asg(
2298: l_last_asg_action_id IN NUMBER,
2299: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2300: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2301: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2302: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2303: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2296: -- For aggregated assginments
2297: PROCEDURE get_ni_only_agg_bal_for_asg(
2298: l_last_asg_action_id IN NUMBER,
2299: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2300: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2301: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2302: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2303: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2304: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2297: PROCEDURE get_ni_only_agg_bal_for_asg(
2298: l_last_asg_action_id IN NUMBER,
2299: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2300: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2301: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2302: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2303: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2304: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2305: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2298: l_last_asg_action_id IN NUMBER,
2299: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2300: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2301: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2302: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2303: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2304: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2305: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2306: IS
2299: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2300: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2301: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2302: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2303: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2304: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2305: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2306: IS
2307: -- local variables to store NI total and able balances
2300: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2301: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2302: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2303: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2304: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2305: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2306: IS
2307: -- local variables to store NI total and able balances
2308: l_nia_tot NUMBER(15,2) :=0;
2301: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2302: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2303: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2304: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2305: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2306: IS
2307: -- local variables to store NI total and able balances
2308: l_nia_tot NUMBER(15,2) :=0;
2309: l_nia_able NUMBER(15,2) :=0;
2613:
2614: -- new cursor for NI only aggregation case:
2615: PROCEDURE get_ni_only_agg_bal_sum_asg(
2616: l_last_asg_action_id IN NUMBER,
2617: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2618: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2619: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2620: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2621: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2614: -- new cursor for NI only aggregation case:
2615: PROCEDURE get_ni_only_agg_bal_sum_asg(
2616: l_last_asg_action_id IN NUMBER,
2617: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2618: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2619: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2620: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2621: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2622: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2615: PROCEDURE get_ni_only_agg_bal_sum_asg(
2616: l_last_asg_action_id IN NUMBER,
2617: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2618: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2619: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2620: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2621: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2622: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2623: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2616: l_last_asg_action_id IN NUMBER,
2617: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2618: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2619: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2620: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2621: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2622: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2623: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2624: IS
2617: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2618: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2619: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2620: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2621: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2622: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2623: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2624: IS
2625: -- local variables to store NI total and able balances
2618: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2619: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2620: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2621: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2622: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2623: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2624: IS
2625: -- local variables to store NI total and able balances
2626: l_nia_tot NUMBER(15,2) :=0;
2619: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2620: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2621: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2622: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
2623: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec )
2624: IS
2625: -- local variables to store NI total and able balances
2626: l_nia_tot NUMBER(15,2) :=0;
2627: l_nia_able NUMBER(15,2) :=0;
3299: INTO l_insert_bacs
3300: FROM pqp_configuration_values
3301: WHERE business_group_id = l_business_group_id
3302:
3303: AND pcv_information_category = 'PAY_GB_RTI_FPS_BACS'
3304: AND pcv_information1 = l_tax_ref
3305: AND l_effective_date >= fnd_date.canonical_to_date(PCV_INFORMATION2);
3306: EXCEPTION
3307: WHEN OTHERS THEN