DBA Data[Home] [Help]

APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PAY_DEFINED_BALANCES

Line 30: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;

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;

Line 31: g_nia_able_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;

Line 32: g_nia_tot_id 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;

Line 33: g_nia_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;

Line 34: g_nib_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;

Line 35: g_nic_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;

Line 36: g_nid_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;

Line 37: g_nie_tot_id_run 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;

Line 38: g_nij_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;
42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 39: g_nil_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
43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 40: g_nia_lel_id 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
44: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 41: g_nia_uel_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;

Line 42: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

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;

Line 43: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

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;

Line 44: g_nia_et_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;

Line 45: g_nib_able_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;

Line 46: g_nib_able_id_run 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

Line 47: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 48: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

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;

Line 49: g_nib_uel_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;

Line 50: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

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;

Line 51: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

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;

Line 52: g_nib_et_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;

Line 53: g_nic_able_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;

Line 54: g_nic_able_id_run 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

Line 55: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 56: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

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;

Line 57: g_nic_uel_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;

Line 58: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

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;

Line 59: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

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;

Line 60: g_nic_et_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;
64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 61: g_nic_ers_rebate_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;

Line 62: g_nid_able_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;

Line 63: g_nid_able_id_run 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

Line 64: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 65: g_nid_lel_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
69: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 66: g_nid_uel_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;

Line 67: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

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;

Line 68: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

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;

Line 69: g_nid_et_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;

Line 70: g_nid_ers_rebate_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;

Line 71: g_nid_ees_rebate_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;
75: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 72: g_nid_rebate_emp_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;

Line 73: g_nie_able_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;

Line 74: g_nie_able_id_run 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

Line 75: g_nie_tot_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
79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 76: g_nie_lel_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
80: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 77: g_nie_uel_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;

Line 78: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

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;

Line 79: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

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;

Line 80: g_nie_et_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;

Line 81: g_nie_ers_rebate_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;
85: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 82: g_nig_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;

Line 83: g_nij_able_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;

Line 84: g_nij_able_id_run 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

Line 85: g_nij_tot_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
89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 86: g_nij_lel_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
90: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 87: g_nij_uel_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;

Line 88: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

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;

Line 89: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

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;

Line 90: g_nij_et_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;

Line 91: g_nil_able_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;

Line 92: g_nil_able_id_run 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

Line 93: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 94: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

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;

Line 95: g_nil_uel_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;

Line 96: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

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;

Line 97: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

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;

Line 98: g_nil_et_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;

Line 99: g_nia_e_ytd_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;

Line 100: g_nia_e_ptd_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;

Line 101: g_nia_r_ytd_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;

Line 102: g_nia_r_ptd_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;

Line 103: g_nib_e_ytd_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;

Line 104: g_nib_e_ptd_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;

Line 105: g_nib_r_ytd_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;

Line 106: g_nib_r_ptd_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;

Line 107: g_nic_e_ytd_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;

Line 108: g_nic_e_ptd_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;

Line 109: g_nic_r_ytd_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;

Line 110: g_nic_r_ptd_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;

Line 111: g_nid_e_ytd_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;

Line 112: g_nid_e_ptd_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;

Line 113: g_nid_r_ytd_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;

Line 114: g_nid_r_ptd_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;

Line 115: g_nie_e_ytd_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;

Line 116: g_nie_e_ptd_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;

Line 117: g_nie_r_ytd_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;

Line 118: g_nie_r_ptd_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;

Line 119: g_nij_e_ytd_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;

Line 120: g_nij_e_ptd_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;

Line 121: g_nij_r_ytd_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;

Line 122: g_nij_r_ptd_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;

Line 123: g_nil_e_ytd_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

Line 124: g_nil_e_ptd_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
128: IS

Line 125: g_nil_r_ytd_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
129: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)

Line 126: g_nil_r_ptd_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)
130: IS

Line 132: FROM pay_defined_balances db,

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

Line 541: FROM pay_defined_balances db,

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

Line 1023: FROM pay_defined_balances pdb,

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

Line 1354: FROM pay_defined_balances pdb,

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

Line 1692: FROM pay_defined_balances pdb,

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

Line 2362: FROM pay_defined_balances pdb,

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

Line 2647: FROM pay_defined_balances pdb,

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