DBA Data[Home] [Help]

APPS.PAY_GB_FPS_NI_AND_OTHERS dependencies on PAY_GB_RTI_FPS

Line 981: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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,

Line 982: p_ni_b_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,

Line 983: p_ni_c_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 )

Line 984: p_ni_d_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

Line 985: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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

Line 986: p_ni_j_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
990: l_nia_tot NUMBER(15,2) :=0;

Line 987: p_ni_l_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;
991: l_nia_able NUMBER(15,2) :=0;

Line 1308: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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,

Line 1309: p_ni_b_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,

Line 1310: p_ni_c_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 )

Line 1311: p_ni_d_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

Line 1312: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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

Line 1313: p_ni_j_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
1317: l_nia_tot NUMBER(15,2) :=0;

Line 1314: p_ni_l_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;
1318: l_nia_able NUMBER(15,2) :=0;

Line 1636: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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,

Line 1637: p_ni_b_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,

Line 1638: p_ni_c_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 )

Line 1639: p_ni_d_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

Line 1640: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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

Line 1641: p_ni_j_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
1645: l_nia_tot NUMBER(15,2) :=0;

Line 1642: p_ni_l_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;
1646: l_nia_able NUMBER(15,2) :=0;

Line 2299: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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,

Line 2300: p_ni_b_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,

Line 2301: p_ni_c_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 )

Line 2302: p_ni_d_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

Line 2303: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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

Line 2304: p_ni_j_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
2308: l_nia_tot NUMBER(15,2) :=0;

Line 2305: p_ni_l_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;
2309: l_nia_able NUMBER(15,2) :=0;

Line 2617: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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,

Line 2618: p_ni_b_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,

Line 2619: p_ni_c_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 )

Line 2620: p_ni_d_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

Line 2621: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,

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

Line 2622: p_ni_j_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
2626: l_nia_tot NUMBER(15,2) :=0;

Line 2623: p_ni_l_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;
2627: l_nia_able NUMBER(15,2) :=0;

Line 3303: AND pcv_information_category = 'PAY_GB_RTI_FPS_BACS'

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