DBA Data[Home] [Help]

APPS.PAY_GB_FPS_NI_AND_OTHERS dependencies on PAY_DEFINED_BALANCES

Line 63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;

59: =============================================================================*/
60: --
61: --
62: -- Declare variables to hold NI Defined balance id's
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;

60: --
61: --
62: -- Declare variables to hold NI Defined balance id's
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;

61: --
62: -- Declare variables to hold NI Defined balance id's
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

62: -- Declare variables to hold NI Defined balance id's
63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

63: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

64: g_nia_able_id_run pay_defined_balances.defined_balance_id%TYPE;
65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

65: g_nia_tot_id pay_defined_balances.defined_balance_id%TYPE;
66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

66: g_nia_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

67: g_nib_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;

68: g_nic_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;

69: g_nid_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;

70: g_nie_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;

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

71: g_nij_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;

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

72: g_nil_tot_id_run pay_defined_balances.defined_balance_id%TYPE;
73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;

73: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;

74: g_nia_uel_id pay_defined_balances.defined_balance_id%TYPE;
75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;

75: g_nia_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;

76: g_nia_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;

77: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;

78: g_nib_able_id pay_defined_balances.defined_balance_id%TYPE;
79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;

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

79: g_nib_able_id_run pay_defined_balances.defined_balance_id%TYPE;
80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;

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

80: g_nib_tot_id pay_defined_balances.defined_balance_id%TYPE;
81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;

81: g_nib_lel_id pay_defined_balances.defined_balance_id%TYPE;
82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;

82: g_nib_uel_id pay_defined_balances.defined_balance_id%TYPE;
83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;

83: g_nib_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;

84: g_nib_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;

85: g_nib_et_id pay_defined_balances.defined_balance_id%TYPE;
86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;

86: g_nic_able_id pay_defined_balances.defined_balance_id%TYPE;
87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

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

87: g_nic_able_id_run pay_defined_balances.defined_balance_id%TYPE;
88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;

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

88: g_nic_tot_id pay_defined_balances.defined_balance_id%TYPE;
89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;

89: g_nic_lel_id pay_defined_balances.defined_balance_id%TYPE;
90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

90: g_nic_uel_id pay_defined_balances.defined_balance_id%TYPE;
91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;

91: g_nic_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;

92: g_nic_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;

93: g_nic_et_id pay_defined_balances.defined_balance_id%TYPE;
94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;

94: g_nic_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;

95: g_nid_able_id pay_defined_balances.defined_balance_id%TYPE;
96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

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

96: g_nid_able_id_run pay_defined_balances.defined_balance_id%TYPE;
97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

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

97: g_nid_tot_id pay_defined_balances.defined_balance_id%TYPE;
98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;

Line 102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;

98: g_nid_lel_id pay_defined_balances.defined_balance_id%TYPE;
99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

99: g_nid_uel_id pay_defined_balances.defined_balance_id%TYPE;
100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;

100: g_nid_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;

101: g_nid_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;

102: g_nid_et_id pay_defined_balances.defined_balance_id%TYPE;
103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;

103: g_nid_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;

104: g_nid_ees_rebate_id pay_defined_balances.defined_balance_id%TYPE;
105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;

105: g_nid_rebate_emp_id pay_defined_balances.defined_balance_id%TYPE;
106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;

106: g_nie_able_id pay_defined_balances.defined_balance_id%TYPE;
107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

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

107: g_nie_able_id_run pay_defined_balances.defined_balance_id%TYPE;
108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;

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

108: g_nie_tot_id pay_defined_balances.defined_balance_id%TYPE;
109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;

109: g_nie_lel_id pay_defined_balances.defined_balance_id%TYPE;
110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;

Line 114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;

110: g_nie_uel_id pay_defined_balances.defined_balance_id%TYPE;
111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;

111: g_nie_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;

112: g_nie_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;

113: g_nie_et_id pay_defined_balances.defined_balance_id%TYPE;
114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;

114: g_nie_ers_rebate_id pay_defined_balances.defined_balance_id%TYPE;
115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;

115: g_nig_tot_id pay_defined_balances.defined_balance_id%TYPE;
116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;

116: g_nij_able_id pay_defined_balances.defined_balance_id%TYPE;
117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;

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

117: g_nij_able_id_run pay_defined_balances.defined_balance_id%TYPE;
118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;

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

118: g_nij_tot_id pay_defined_balances.defined_balance_id%TYPE;
119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;

Line 123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;

119: g_nij_lel_id pay_defined_balances.defined_balance_id%TYPE;
120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

Line 124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;

120: g_nij_uel_id pay_defined_balances.defined_balance_id%TYPE;
121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;

Line 125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;

121: g_nij_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870

Line 126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;

122: g_nij_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08

Line 127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;

123: g_nij_et_id pay_defined_balances.defined_balance_id%TYPE;
124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

Line 128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;

124: g_nil_able_id pay_defined_balances.defined_balance_id%TYPE;
125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

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

125: g_nil_able_id_run pay_defined_balances.defined_balance_id%TYPE;
126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

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

126: g_nil_tot_id pay_defined_balances.defined_balance_id%TYPE;
127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;

127: g_nil_lel_id pay_defined_balances.defined_balance_id%TYPE;
128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

128: g_nil_uel_id pay_defined_balances.defined_balance_id%TYPE;
129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

129: g_nil_uap_id pay_defined_balances.defined_balance_id%TYPE; -- 8357870
130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

130: g_nil_auel_id pay_defined_balances.defined_balance_id%TYPE; --EOY 07/08
131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

131: g_nil_et_id pay_defined_balances.defined_balance_id%TYPE;
132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

132: g_nia_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

133: g_nia_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

134: g_nia_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

135: g_nia_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

136: g_nib_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

137: g_nib_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

138: g_nib_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

139: g_nib_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

140: g_nic_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

141: g_nic_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

142: g_nic_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

143: g_nic_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

144: g_nid_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

145: g_nid_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

146: g_nid_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

147: g_nid_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

148: g_nie_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

149: g_nie_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

150: g_nie_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

Line 155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

151: g_nie_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

Line 156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;

152: g_nij_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
160: PROCEDURE load_defined_balances

Line 157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;

153: g_nij_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
160: PROCEDURE load_defined_balances
161: IS

Line 158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;

154: g_nij_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
160: PROCEDURE load_defined_balances
161: IS
162: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)

Line 159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;

155: g_nij_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
156: g_nil_e_ytd_id pay_defined_balances.defined_balance_id%TYPE;
157: g_nil_e_ptd_id pay_defined_balances.defined_balance_id%TYPE;
158: g_nil_r_ytd_id pay_defined_balances.defined_balance_id%TYPE;
159: g_nil_r_ptd_id pay_defined_balances.defined_balance_id%TYPE;
160: PROCEDURE load_defined_balances
161: IS
162: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
163: IS

Line 165: FROM pay_defined_balances db,

161: IS
162: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
163: IS
164: SELECT defined_balance_id
165: FROM pay_defined_balances db,
166: pay_balance_types b,
167: pay_balance_dimensions d
168: WHERE b.balance_name = p_balance_name
169: AND d.dimension_name = p_dimension_name

Line 574: FROM pay_defined_balances db,

570: IS
571: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
572: IS
573: SELECT defined_balance_id
574: FROM pay_defined_balances db,
575: pay_balance_types b,
576: pay_balance_dimensions d
577: WHERE b.balance_name = p_balance_name
578: AND d.dimension_name = p_dimension_name

Line 1059: FROM pay_defined_balances pdb,

1055: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1056: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1057: IS
1058: SELECT pdb.defined_balance_id
1059: FROM pay_defined_balances pdb,
1060: pay_balance_dimensions pbd,
1061: pay_balance_types pbt
1062: WHERE pbt.balance_name = c_balance_name
1063: AND pbd.database_item_suffix = c_dim_name

Line 1383: FROM pay_defined_balances pdb,

1379: WHERE SOURCE_ACTION_ID = c_lst_act_id;
1380: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1381: IS
1382: SELECT pdb.defined_balance_id
1383: FROM pay_defined_balances pdb,
1384: pay_balance_dimensions pbd,
1385: pay_balance_types pbt
1386: WHERE pbt.balance_name = c_balance_name
1387: AND pbd.database_item_suffix = c_dim_name

Line 1715: FROM pay_defined_balances pdb,

1711:
1712: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1713: IS
1714: SELECT pdb.defined_balance_id
1715: FROM pay_defined_balances pdb,
1716: pay_balance_dimensions pbd,
1717: pay_balance_types pbt
1718: WHERE pbt.balance_name = c_balance_name
1719: AND pbd.database_item_suffix = c_dim_name

Line 2374: FROM pay_defined_balances pdb,

2370: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2371: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2372: IS
2373: SELECT pdb.defined_balance_id
2374: FROM pay_defined_balances pdb,
2375: pay_balance_dimensions pbd,
2376: pay_balance_types pbt
2377: WHERE pbt.balance_name = c_balance_name
2378: AND pbd.database_item_suffix = c_dim_name

Line 2652: FROM pay_defined_balances pdb,

2648: WHERE SOURCE_ACTION_ID = c_lst_act_id;
2649: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2650: IS
2651: SELECT pdb.defined_balance_id
2652: FROM pay_defined_balances pdb,
2653: pay_balance_dimensions pbd,
2654: pay_balance_types pbt
2655: WHERE pbt.balance_name = c_balance_name
2656: AND pbd.database_item_suffix = c_dim_name