26: =============================================================================*/
27: --
28: --
29: -- Declare variables to hold NI Defined balance id's
30: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
31: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
32: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
27: --
28: --
29: -- Declare variables to hold NI Defined balance id's
30: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
31: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
32: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
28: --
29: -- Declare variables to hold NI Defined balance id's
30: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
31: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
32: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
29: -- Declare variables to hold NI Defined balance id's
30: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
31: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
32: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
30: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
31: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
32: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
31: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
32: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
32: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
33: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
34: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
35: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
36: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
37: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
38: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
39: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
40: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
41: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
45: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
46: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
49: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
52: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
53: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
57: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
60: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
61: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
62: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
63: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
65: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
70: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
71: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
72: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
73: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
76: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
77: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
81: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
82: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
84: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
92: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
101: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
102: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
108: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
112: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
113: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
118: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
127: PROCEDURE load_defined_balances
120: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
127: PROCEDURE load_defined_balances
128: IS
121: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
127: PROCEDURE load_defined_balances
128: IS
129: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
122: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
123: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
127: PROCEDURE load_defined_balances
128: IS
129: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
130: IS
128: IS
129: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
130: IS
131: SELECT defined_balance_id
132: FROM pay_defined_balances db,
133: pay_balance_types b,
134: pay_balance_dimensions d
135: WHERE b.balance_name = p_balance_name
136: AND d.dimension_name = p_dimension_name
537: IS
538: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
539: IS
540: SELECT defined_balance_id
541: FROM pay_defined_balances db,
542: pay_balance_types b,
543: pay_balance_dimensions d
544: WHERE b.balance_name = p_balance_name
545: AND d.dimension_name = p_dimension_name
1019: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1020: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1021: IS
1022: SELECT pdb.defined_balance_id
1023: FROM pay_defined_balances pdb,
1024: pay_balance_dimensions pbd,
1025: pay_balance_types pbt
1026: WHERE pbt.balance_name = c_balance_name
1027: AND pbd.database_item_suffix = c_dim_name
1350: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1351: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1352: IS
1353: SELECT pdb.defined_balance_id
1354: FROM pay_defined_balances pdb,
1355: pay_balance_dimensions pbd,
1356: pay_balance_types pbt
1357: WHERE pbt.balance_name = c_balance_name
1358: AND pbd.database_item_suffix = c_dim_name
1688:
1689: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1690: IS
1691: SELECT pdb.defined_balance_id
1692: FROM pay_defined_balances pdb,
1693: pay_balance_dimensions pbd,
1694: pay_balance_types pbt
1695: WHERE pbt.balance_name = c_balance_name
1696: AND pbd.database_item_suffix = c_dim_name
2358: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2359: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2360: IS
2361: SELECT pdb.defined_balance_id
2362: FROM pay_defined_balances pdb,
2363: pay_balance_dimensions pbd,
2364: pay_balance_types pbt
2365: WHERE pbt.balance_name = c_balance_name
2366: AND pbd.database_item_suffix = c_dim_name
2643: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2644: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2645: IS
2646: SELECT pdb.defined_balance_id
2647: FROM pay_defined_balances pdb,
2648: pay_balance_dimensions pbd,
2649: pay_balance_types pbt
2650: WHERE pbt.balance_name = c_balance_name
2651: AND pbd.database_item_suffix = c_dim_name