eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PAY_GB_RTI_FPS_ARCHIVE

Line 948: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

944:
945: PROCEDURE get_ni_bal_paye_aggr_for_asg(
946: p_asg_id IN NUMBER,
947: l_last_asg_action_id IN NUMBER,
948: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
949: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
950: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
951: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
952: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 949: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

945: PROCEDURE get_ni_bal_paye_aggr_for_asg(
946: p_asg_id IN NUMBER,
947: l_last_asg_action_id IN NUMBER,
948: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
949: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
950: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
951: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
952: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
953: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 950: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

946: p_asg_id IN NUMBER,
947: l_last_asg_action_id IN NUMBER,
948: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
949: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
950: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
951: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
952: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
953: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
954: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )

Line 951: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

947: l_last_asg_action_id IN NUMBER,
948: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
949: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
950: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
951: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
952: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
953: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
954: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
955: IS

Line 952: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

948: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
949: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
950: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
951: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
952: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
953: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
954: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
955: IS
956: -- local variables to store NI total and able balances

Line 953: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

949: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
950: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
951: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
952: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
953: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
954: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
955: IS
956: -- local variables to store NI total and able balances
957: l_nia_tot NUMBER(15,2) :=0;

Line 954: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )

950: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
951: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
952: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
953: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
954: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
955: IS
956: -- local variables to store NI total and able balances
957: l_nia_tot NUMBER(15,2) :=0;
958: l_nia_able NUMBER(15,2) :=0;

Line 1279: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1275: END get_ni_bal_paye_aggr_for_asg;
1276:
1277: PROCEDURE get_ni_only_bal_rti_rpt(
1278: l_last_asg_action_id IN NUMBER,
1279: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1280: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1281: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1282: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1283: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 1280: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1276:
1277: PROCEDURE get_ni_only_bal_rti_rpt(
1278: l_last_asg_action_id IN NUMBER,
1279: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1280: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1281: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1282: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1283: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1284: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 1281: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1277: PROCEDURE get_ni_only_bal_rti_rpt(
1278: l_last_asg_action_id IN NUMBER,
1279: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1280: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1281: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1282: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1283: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1284: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1285: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec )

Line 1282: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1278: l_last_asg_action_id IN NUMBER,
1279: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1280: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1281: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1282: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1283: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1284: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1285: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec )
1286: IS

Line 1283: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1279: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1280: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1281: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1282: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1283: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1284: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1285: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec )
1286: IS
1287: -- local variables to store NI total and able balances

Line 1284: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1280: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1281: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1282: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1283: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1284: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1285: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec )
1286: IS
1287: -- local variables to store NI total and able balances
1288: l_nia_tot NUMBER(15,2) :=0;

Line 1285: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec )

1281: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1282: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1283: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1284: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1285: p_ni_l_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec )
1286: IS
1287: -- local variables to store NI total and able balances
1288: l_nia_tot NUMBER(15,2) :=0;
1289: l_nia_able NUMBER(15,2) :=0;

Line 1614: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1610: */
1611:
1612: PROCEDURE get_ni_balances_for_asg(
1613: l_last_asg_action_id IN NUMBER,
1614: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1615: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1616: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1617: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1618: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 1615: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1611:
1612: PROCEDURE get_ni_balances_for_asg(
1613: l_last_asg_action_id IN NUMBER,
1614: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1615: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1616: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1617: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1618: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1619: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 1616: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1612: PROCEDURE get_ni_balances_for_asg(
1613: l_last_asg_action_id IN NUMBER,
1614: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1615: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1616: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1617: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1618: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1619: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1620: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )

Line 1617: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1613: l_last_asg_action_id IN NUMBER,
1614: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1615: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1616: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1617: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1618: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1619: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1620: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
1621: IS

Line 1618: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1614: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1615: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1616: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1617: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1618: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1619: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1620: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
1621: IS
1622: -- local variables to store NI total and able balances

Line 1619: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

1615: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1616: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1617: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1618: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1619: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1620: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
1621: IS
1622: -- local variables to store NI total and able balances
1623: l_nia_tot NUMBER(15,2) :=0;

Line 1620: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )

1616: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1617: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1618: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1619: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
1620: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
1621: IS
1622: -- local variables to store NI total and able balances
1623: l_nia_tot NUMBER(15,2) :=0;
1624: l_nia_able NUMBER(15,2) :=0;

Line 2287: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2283:
2284: -- For aggregated assginments
2285: PROCEDURE get_ni_only_agg_bal_for_asg(
2286: l_last_asg_action_id IN NUMBER,
2287: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2288: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2289: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2290: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2291: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 2288: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2284: -- For aggregated assginments
2285: PROCEDURE get_ni_only_agg_bal_for_asg(
2286: l_last_asg_action_id IN NUMBER,
2287: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2288: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2289: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2290: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2291: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2292: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 2289: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2285: PROCEDURE get_ni_only_agg_bal_for_asg(
2286: l_last_asg_action_id IN NUMBER,
2287: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2288: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2289: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2290: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2291: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2292: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2293: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )

Line 2290: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2286: l_last_asg_action_id IN NUMBER,
2287: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2288: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2289: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2290: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2291: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2292: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2293: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
2294: IS

Line 2291: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2287: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2288: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2289: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2290: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2291: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2292: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2293: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
2294: IS
2295: -- local variables to store NI total and able balances

Line 2292: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2288: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2289: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2290: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2291: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2292: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2293: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
2294: IS
2295: -- local variables to store NI total and able balances
2296: l_nia_tot NUMBER(15,2) :=0;

Line 2293: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )

2289: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2290: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2291: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2292: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2293: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
2294: IS
2295: -- local variables to store NI total and able balances
2296: l_nia_tot NUMBER(15,2) :=0;
2297: l_nia_able NUMBER(15,2) :=0;

Line 2612: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2608:
2609: -- new cursor for NI only aggregation case:
2610: PROCEDURE get_ni_only_agg_bal_sum_asg(
2611: l_last_asg_action_id IN NUMBER,
2612: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2613: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2614: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2615: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2616: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 2613: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2609: -- new cursor for NI only aggregation case:
2610: PROCEDURE get_ni_only_agg_bal_sum_asg(
2611: l_last_asg_action_id IN NUMBER,
2612: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2613: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2614: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2615: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2616: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2617: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

Line 2614: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2610: PROCEDURE get_ni_only_agg_bal_sum_asg(
2611: l_last_asg_action_id IN NUMBER,
2612: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2613: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2614: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2615: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2616: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2617: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2618: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )

Line 2615: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2611: l_last_asg_action_id IN NUMBER,
2612: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2613: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2614: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2615: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2616: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2617: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2618: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
2619: IS

Line 2616: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2612: p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2613: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2614: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2615: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2616: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2617: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2618: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
2619: IS
2620: -- local variables to store NI total and able balances

Line 2617: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,

2613: p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2614: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2615: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2616: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2617: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2618: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
2619: IS
2620: -- local variables to store NI total and able balances
2621: l_nia_tot NUMBER(15,2) :=0;

Line 2618: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )

2614: p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2615: p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2616: p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2617: p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
2618: P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC )
2619: IS
2620: -- local variables to store NI total and able balances
2621: l_nia_tot NUMBER(15,2) :=0;
2622: l_nia_able NUMBER(15,2) :=0;