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

APPS.PAY_GB_EOY_ARCHIVE dependencies on FF_USER_ENTITIES

Line 107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;

103: g_category_input_id pay_input_values_f.input_value_id%TYPE;
104: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
105: g_process_type_id pay_input_values_f.input_value_id%TYPE;
106: --
107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;

Line 108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;

104: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
105: g_process_type_id pay_input_values_f.input_value_id%TYPE;
106: --
107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
112: g_county_eid ff_user_entities.user_entity_id%TYPE;

Line 109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;

105: g_process_type_id pay_input_values_f.input_value_id%TYPE;
106: --
107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
112: g_county_eid ff_user_entities.user_entity_id%TYPE;
113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;

Line 110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263

106: --
107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
112: g_county_eid ff_user_entities.user_entity_id%TYPE;
113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;

107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
112: g_county_eid ff_user_entities.user_entity_id%TYPE;
113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;

Line 112: g_county_eid ff_user_entities.user_entity_id%TYPE;

108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
112: g_county_eid ff_user_entities.user_entity_id%TYPE;
113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;

Line 113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;

109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
112: g_county_eid ff_user_entities.user_entity_id%TYPE;
113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;

110: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
112: g_county_eid ff_user_entities.user_entity_id%TYPE;
113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;

Line 115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;

111: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
112: g_county_eid ff_user_entities.user_entity_id%TYPE;
113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;

Line 116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;

112: g_county_eid ff_user_entities.user_entity_id%TYPE;
113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;

113: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;

114: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;

Line 119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;

115: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;

Line 120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;

116: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;

Line 121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;

117: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;

118: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;

Line 123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;

119: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;

Line 124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;

120: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;

Line 125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;

121: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;

Line 126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;

122: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;

123: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;

Line 128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;

124: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;

Line 129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;

125: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;

Line 130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;

126: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;

Line 131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;

127: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870

Line 132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;

128: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08

Line 133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;

129: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;

Line 134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;

130: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;

Line 135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870

131: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;

Line 136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08

132: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;

Line 137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;

133: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
141: /* EOY 2012/2013 changes */

Line 138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;

134: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
141: /* EOY 2012/2013 changes */
142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;

Line 139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;

135: g_ni_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
141: /* EOY 2012/2013 changes */
142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;

Line 140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;

136: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
137: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
141: /* EOY 2012/2013 changes */
142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;

Line 142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;

138: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
141: /* EOY 2012/2013 changes */
142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870

Line 143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;

139: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
141: /* EOY 2012/2013 changes */
142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08

Line 144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;

140: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
141: /* EOY 2012/2013 changes */
142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;

Line 145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;

141: /* EOY 2012/2013 changes */
142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;

Line 146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870

142: --g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;

Line 147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08

143: --g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;

Line 148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;

144: --g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
152: /* EOY 2012/2013 changes */

Line 149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;

145: --g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
152: /* EOY 2012/2013 changes */
153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;

Line 150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;

146: --g_ni_scon_able_uap_eid ff_user_entities.user_entity_id%TYPE; -- 8357870
147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
152: /* EOY 2012/2013 changes */
153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;

Line 151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;

147: --g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
148: --g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
152: /* EOY 2012/2013 changes */
153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;

Line 153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;

149: --g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
152: /* EOY 2012/2013 changes */
153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;

Line 154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;

150: --g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
152: /* EOY 2012/2013 changes */
153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

Line 155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;

151: --g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
152: /* EOY 2012/2013 changes */
153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;

Line 156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;

152: /* EOY 2012/2013 changes */
153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;

Line 157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;

153: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

154: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;

Line 159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;

155: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;

Line 160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;

156: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;

Line 161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;

157: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;

Line 162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;

158: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;

159: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;

160: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_sex_eid ff_user_entities.user_entity_id%TYPE;

Line 165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;

161: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_sex_eid ff_user_entities.user_entity_id%TYPE;
169: g_smp_eid ff_user_entities.user_entity_id%TYPE;

Line 166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

162: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_sex_eid ff_user_entities.user_entity_id%TYPE;
169: g_smp_eid ff_user_entities.user_entity_id%TYPE;
170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;

Line 167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

163: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_sex_eid ff_user_entities.user_entity_id%TYPE;
169: g_smp_eid ff_user_entities.user_entity_id%TYPE;
170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
171: g_sap_eid ff_user_entities.user_entity_id%TYPE;

Line 168: g_sex_eid ff_user_entities.user_entity_id%TYPE;

164: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_sex_eid ff_user_entities.user_entity_id%TYPE;
169: g_smp_eid ff_user_entities.user_entity_id%TYPE;
170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
171: g_sap_eid ff_user_entities.user_entity_id%TYPE;
172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;

Line 169: g_smp_eid ff_user_entities.user_entity_id%TYPE;

165: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_sex_eid ff_user_entities.user_entity_id%TYPE;
169: g_smp_eid ff_user_entities.user_entity_id%TYPE;
170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
171: g_sap_eid ff_user_entities.user_entity_id%TYPE;
172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
173: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;

Line 170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;

166: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_sex_eid ff_user_entities.user_entity_id%TYPE;
169: g_smp_eid ff_user_entities.user_entity_id%TYPE;
170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
171: g_sap_eid ff_user_entities.user_entity_id%TYPE;
172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
173: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
174: -- EOY Changes 2011/12

Line 171: g_sap_eid ff_user_entities.user_entity_id%TYPE;

167: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_sex_eid ff_user_entities.user_entity_id%TYPE;
169: g_smp_eid ff_user_entities.user_entity_id%TYPE;
170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
171: g_sap_eid ff_user_entities.user_entity_id%TYPE;
172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
173: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
174: -- EOY Changes 2011/12
175: g_aspp_adopt_eid ff_user_entities.user_entity_id%TYPE;

Line 172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;

168: g_sex_eid ff_user_entities.user_entity_id%TYPE;
169: g_smp_eid ff_user_entities.user_entity_id%TYPE;
170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
171: g_sap_eid ff_user_entities.user_entity_id%TYPE;
172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
173: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
174: -- EOY Changes 2011/12
175: g_aspp_adopt_eid ff_user_entities.user_entity_id%TYPE;
176: g_aspp_birth_eid ff_user_entities.user_entity_id%TYPE;

Line 173: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;

169: g_smp_eid ff_user_entities.user_entity_id%TYPE;
170: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
171: g_sap_eid ff_user_entities.user_entity_id%TYPE;
172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
173: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
174: -- EOY Changes 2011/12
175: g_aspp_adopt_eid ff_user_entities.user_entity_id%TYPE;
176: g_aspp_birth_eid ff_user_entities.user_entity_id%TYPE;
177: --

Line 175: g_aspp_adopt_eid ff_user_entities.user_entity_id%TYPE;

171: g_sap_eid ff_user_entities.user_entity_id%TYPE;
172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
173: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
174: -- EOY Changes 2011/12
175: g_aspp_adopt_eid ff_user_entities.user_entity_id%TYPE;
176: g_aspp_birth_eid ff_user_entities.user_entity_id%TYPE;
177: --
178: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 176: g_aspp_birth_eid ff_user_entities.user_entity_id%TYPE;

172: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
173: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
174: -- EOY Changes 2011/12
175: g_aspp_adopt_eid ff_user_entities.user_entity_id%TYPE;
176: g_aspp_birth_eid ff_user_entities.user_entity_id%TYPE;
177: --
178: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;

Line 178: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;

174: -- EOY Changes 2011/12
175: g_aspp_adopt_eid ff_user_entities.user_entity_id%TYPE;
176: g_aspp_birth_eid ff_user_entities.user_entity_id%TYPE;
177: --
178: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;

Line 179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;

175: g_aspp_adopt_eid ff_user_entities.user_entity_id%TYPE;
176: g_aspp_birth_eid ff_user_entities.user_entity_id%TYPE;
177: --
178: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;

176: g_aspp_birth_eid ff_user_entities.user_entity_id%TYPE;
177: --
178: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;

Line 181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;

177: --
178: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;

Line 182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;

178: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;

Line 183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

179: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;

Line 184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;

180: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;

181: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;

Line 186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;

182: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;

Line 187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;

183: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
191: g_title_eid ff_user_entities.user_entity_id%TYPE;

Line 188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

184: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
191: g_title_eid ff_user_entities.user_entity_id%TYPE;
192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;

Line 189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;

185: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
191: g_title_eid ff_user_entities.user_entity_id%TYPE;
192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;

186: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
191: g_title_eid ff_user_entities.user_entity_id%TYPE;
192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 191: g_title_eid ff_user_entities.user_entity_id%TYPE;

187: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
191: g_title_eid ff_user_entities.user_entity_id%TYPE;
192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;

Line 192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;

188: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
191: g_title_eid ff_user_entities.user_entity_id%TYPE;
192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;

Line 193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;

189: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
191: g_title_eid ff_user_entities.user_entity_id%TYPE;
192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;

Line 194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;

190: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
191: g_title_eid ff_user_entities.user_entity_id%TYPE;
192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;

Line 195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;

191: g_title_eid ff_user_entities.user_entity_id%TYPE;
192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
199: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;

Line 196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;

192: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
199: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
200: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;

Line 197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;

193: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
199: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
200: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
201: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;

Line 198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;

194: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
199: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
200: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
201: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;
202: --

Line 199: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;

195: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
199: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
200: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
201: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;
202: --
203: -- start/end year cache globals initialised in cache_archive_value:

Line 200: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;

196: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
199: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
200: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
201: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;
202: --
203: -- start/end year cache globals initialised in cache_archive_value:
204: g_min_start_year DATE;

Line 201: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;

197: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
198: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
199: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
200: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
201: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;
202: --
203: -- start/end year cache globals initialised in cache_archive_value:
204: g_min_start_year DATE;
205: g_max_end_year DATE;

Line 521: l_user_entity_id ff_user_entities.user_entity_id%type;

517: -- two additional contexts. No validation is performed on the input
518: -- parameters. If a matching item does not exist, null is returned.
519: -- The additional context parameters must be populated in order.
520: IS
521: l_user_entity_id ff_user_entities.user_entity_id%type;
522: l_arch_value ff_archive_items.value%type;
523: BEGIN
524: SELECT fue.user_entity_id
525: INTO l_user_entity_id

Line 526: FROM ff_user_entities fue

522: l_arch_value ff_archive_items.value%type;
523: BEGIN
524: SELECT fue.user_entity_id
525: INTO l_user_entity_id
526: FROM ff_user_entities fue
527: WHERE fue.user_entity_name = p_user_entity_name
528: AND fue.legislation_code= 'GB';
529: --
530: l_arch_value := pay_gb_eoy_archive.get_arch_str(p_action_id,

Line 1261: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

1257: l_payroll_period_type VARCHAR2(30);
1258: l_payroll_max_period_number NUMBER;
1259: l_dummy NUMBER;
1260: -- User Entity IDs
1261: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1262: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1263: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;

Line 1262: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;

1258: l_payroll_max_period_number NUMBER;
1259: l_dummy NUMBER;
1260: -- User Entity IDs
1261: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1262: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1263: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;

Line 1263: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;

1259: l_dummy NUMBER;
1260: -- User Entity IDs
1261: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1262: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1263: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1267: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;

Line 1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;

1260: -- User Entity IDs
1261: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1262: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1263: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1267: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1268: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;

Line 1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;

1261: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1262: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1263: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1267: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1268: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1269: l_econ_eid ff_user_entities.user_entity_id%TYPE;

Line 1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;

1262: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1263: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1267: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1268: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1269: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1270:

Line 1267: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;

1263: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1267: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1268: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1269: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1270:
1271: /* Start 4011263

Line 1268: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;

1264: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1267: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1268: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1269: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1270:
1271: /* Start 4011263
1272: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;

Line 1269: l_econ_eid ff_user_entities.user_entity_id%TYPE;

1265: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1266: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1267: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1268: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1269: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1270:
1271: /* Start 4011263
1272: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1273: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;

Line 1272: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;

1268: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1269: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1270:
1271: /* Start 4011263
1272: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1273: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1274: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1275: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1276: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;

Line 1273: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;

1269: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1270:
1271: /* Start 4011263
1272: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1273: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1274: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1275: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1276: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1277: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;

Line 1274: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;

1270:
1271: /* Start 4011263
1272: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1273: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1274: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1275: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1276: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1277: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1278: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;

Line 1275: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;

1271: /* Start 4011263
1272: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1273: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1274: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1275: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1276: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1277: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1278: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1279: End 4011263 */

Line 1276: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;

1272: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1273: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1274: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1275: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1276: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1277: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1278: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1279: End 4011263 */
1280:

Line 1277: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;

1273: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1274: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1275: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1276: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1277: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1278: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1279: End 4011263 */
1280:
1281: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;

Line 1278: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;

1274: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1275: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1276: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1277: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1278: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1279: End 4011263 */
1280:
1281: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1282: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;

Line 1281: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;

1277: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1278: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1279: End 4011263 */
1280:
1281: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1282: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1283: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1284: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1285: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;

Line 1282: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;

1278: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1279: End 4011263 */
1280:
1281: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1282: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1283: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1284: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1285: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;
1286: -- exceptions

Line 1283: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;

1279: End 4011263 */
1280:
1281: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1282: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1283: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1284: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1285: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;
1286: -- exceptions
1287: tax_dist_ref_error EXCEPTION; -- raised when l_tax_district_reference

Line 1284: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;

1280:
1281: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1282: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1283: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1284: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1285: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;
1286: -- exceptions
1287: tax_dist_ref_error EXCEPTION; -- raised when l_tax_district_reference
1288: -- has incorrect format

Line 1285: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;

1281: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1282: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1283: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1284: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1285: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;
1286: -- exceptions
1287: tax_dist_ref_error EXCEPTION; -- raised when l_tax_district_reference
1288: -- has incorrect format
1289: inconsis_ref_error EXCEPTION; -- raised when a payroll has more than

Line 1394: FROM ff_user_entities

1390: AND p_end_year;
1391: --
1392: cursor csr_user_entity(p_entity_name VARCHAR2) IS
1393: SELECT user_entity_id
1394: FROM ff_user_entities
1395: WHERE user_entity_name = p_entity_name
1396: AND legislation_code = 'GB'
1397: AND business_group_id IS NULL;
1398: --

Line 1778: FROM ff_user_entities

1774: WHERE payroll_action_id = p_payroll_action_id;
1775: --
1776: cursor csr_user_entity(p_entity_name VARCHAR2) IS
1777: SELECT user_entity_id
1778: FROM ff_user_entities
1779: WHERE user_entity_name = p_entity_name
1780: AND legislation_code = 'GB'
1781: AND business_group_id IS NULL;
1782: --

Line 2293: FROM ff_user_entities

2289: WHERE payroll_action_id = p_payroll_action_id;
2290: --
2291: cursor csr_user_entity(p_entity_name VARCHAR2) IS
2292: SELECT user_entity_id
2293: FROM ff_user_entities
2294: WHERE user_entity_name = p_entity_name
2295: AND legislation_code = 'GB'
2296: AND business_group_id IS NULL;
2297: --

Line 2320: ff_user_entities fue,

2316: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2317: aic.context) tax_dist
2318: FROM ff_archive_item_contexts aic, /* payrolls */
2319: ff_archive_items fai, /* X_START_YEAR */
2320: ff_user_entities fue,
2321: pay_payroll_actions pact
2322: WHERE pact.report_type = 'EOY'
2323: AND pact.report_qualifier = 'GB'
2324: AND pact.action_type = 'X'

Line 3896: FROM ff_user_entities fue,

3892: -- X_P45_FINAL_PAYMENT_ACTION user entity
3893: --
3894: CURSOR csr_get_final_payment_date(c_asg_action_id NUMBER) IS
3895: SELECT ppa.effective_date
3896: FROM ff_user_entities fue,
3897: ff_archive_items fai,
3898: pay_assignment_actions paa,
3899: pay_payroll_actions ppa
3900: WHERE fue.user_entity_name = 'X_P45_FINAL_PAYMENT_ACTION'

Line 6338: FROM ff_user_entities

6334: -- is specific to Extract Items.
6335: --
6336: cursor csr_get_user_entity_id(c_user_entity_name VARCHAR2) IS
6337: SELECT user_entity_id
6338: FROM ff_user_entities
6339: WHERE user_entity_name = c_user_entity_name;
6340: --
6341: l_user_entity_id NUMBER;
6342: invalid_archive_type EXCEPTION;