59: =============================================================================*/
60: --
61: --
62: -- Declare variables to hold NI Defined balance id's
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
60: --
61: --
62: -- Declare variables to hold NI Defined balance id's
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
61: --
62: -- Declare variables to hold NI Defined balance id's
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
62: -- Declare variables to hold NI Defined balance id's
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
160: PROCEDURE load_defined_balances
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
160: PROCEDURE load_defined_balances
161: IS
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
160: PROCEDURE load_defined_balances
161: IS
162: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
160: PROCEDURE load_defined_balances
161: IS
162: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
163: IS
161: IS
162: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
163: IS
164: SELECT defined_balance_id
165: FROM pay_defined_balances db,
166: pay_balance_types b,
167: pay_balance_dimensions d
168: WHERE b.balance_name = p_balance_name
169: AND d.dimension_name = p_dimension_name
570: IS
571: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
572: IS
573: SELECT defined_balance_id
574: FROM pay_defined_balances db,
575: pay_balance_types b,
576: pay_balance_dimensions d
577: WHERE b.balance_name = p_balance_name
578: AND d.dimension_name = p_dimension_name
1055: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1056: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1057: IS
1058: SELECT pdb.defined_balance_id
1059: FROM pay_defined_balances pdb,
1060: pay_balance_dimensions pbd,
1061: pay_balance_types pbt
1062: WHERE pbt.balance_name = c_balance_name
1063: AND pbd.database_item_suffix = c_dim_name
1379: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1380: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1381: IS
1382: SELECT pdb.defined_balance_id
1383: FROM pay_defined_balances pdb,
1384: pay_balance_dimensions pbd,
1385: pay_balance_types pbt
1386: WHERE pbt.balance_name = c_balance_name
1387: AND pbd.database_item_suffix = c_dim_name
1711:
1712: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1713: IS
1714: SELECT pdb.defined_balance_id
1715: FROM pay_defined_balances pdb,
1716: pay_balance_dimensions pbd,
1717: pay_balance_types pbt
1718: WHERE pbt.balance_name = c_balance_name
1719: AND pbd.database_item_suffix = c_dim_name
2370: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2371: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2372: IS
2373: SELECT pdb.defined_balance_id
2374: FROM pay_defined_balances pdb,
2375: pay_balance_dimensions pbd,
2376: pay_balance_types pbt
2377: WHERE pbt.balance_name = c_balance_name
2378: AND pbd.database_item_suffix = c_dim_name
2648: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2649: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2650: IS
2651: SELECT pdb.defined_balance_id
2652: FROM pay_defined_balances pdb,
2653: pay_balance_dimensions pbd,
2654: pay_balance_types pbt
2655: WHERE pbt.balance_name = c_balance_name
2656: AND pbd.database_item_suffix = c_dim_name