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.

[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on FF_USER_ENTITIES

Line 94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;

90: g_category_input_id pay_input_values_f.input_value_id%TYPE;
91: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
92: g_process_type_id pay_input_values_f.input_value_id%TYPE;
93: --
94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
97: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;

Line 95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;

91: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
92: g_process_type_id pay_input_values_f.input_value_id%TYPE;
93: --
94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
97: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
99: g_county_eid ff_user_entities.user_entity_id%TYPE;

Line 96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;

92: g_process_type_id pay_input_values_f.input_value_id%TYPE;
93: --
94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
97: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
99: g_county_eid ff_user_entities.user_entity_id%TYPE;
100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;

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

93: --
94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
97: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
99: g_county_eid ff_user_entities.user_entity_id%TYPE;
100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;

94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
97: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
99: g_county_eid ff_user_entities.user_entity_id%TYPE;
100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;

Line 99: g_county_eid ff_user_entities.user_entity_id%TYPE;

95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
97: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
99: g_county_eid ff_user_entities.user_entity_id%TYPE;
100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;

Line 100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;

96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
97: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
99: g_county_eid ff_user_entities.user_entity_id%TYPE;
100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;

97: g_country_eid ff_user_entities.user_entity_id%TYPE; -- 4011263
98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
99: g_county_eid ff_user_entities.user_entity_id%TYPE;
100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;

Line 102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;

98: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
99: g_county_eid ff_user_entities.user_entity_id%TYPE;
100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;

Line 103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;

99: g_county_eid ff_user_entities.user_entity_id%TYPE;
100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;

100: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;

101: g_director_indicator_eid ff_user_entities.user_entity_id%TYPE;
102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;

Line 106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;

102: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;

Line 107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;

103: g_effective_start_date_eid ff_user_entities.user_entity_id%TYPE;
104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;

Line 108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;

104: g_eoy_primary_flag_eid ff_user_entities.user_entity_id%TYPE;
105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;

105: g_expense_check_to_address_eid ff_user_entities.user_entity_id%TYPE;
106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;

Line 110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;

106: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;

Line 111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;

107: g_gross_pay_eid ff_user_entities.user_entity_id%TYPE;
108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;

Line 112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;

108: g_notional_pay_eid ff_user_entities.user_entity_id%TYPE;
109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;

Line 113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;

109: g_last_asg_action_id_eid ff_user_entities.user_entity_id%TYPE;
110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;

110: g_last_effective_date_eid ff_user_entities.user_entity_id%TYPE;
111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;

Line 115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;

111: g_last_multi_asg_eid ff_user_entities.user_entity_id%TYPE;
112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;

Line 116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;

112: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;

Line 117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;

113: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;

Line 118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;

114: g_location_id_eid ff_user_entities.user_entity_id%TYPE;
115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08

Line 119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;

115: g_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;

Line 120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;

116: g_middle_name_eid ff_user_entities.user_entity_id%TYPE;
117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;

Line 121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;

117: g_multiple_asg_flag_eid ff_user_entities.user_entity_id%TYPE;
118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;

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

118: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;

Line 123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;

119: g_ni_able_et_eid ff_user_entities.user_entity_id%TYPE;
120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;

Line 124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;

120: g_ni_able_lel_eid ff_user_entities.user_entity_id%TYPE;
121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;

Line 125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;

121: g_ni_able_uel_eid ff_user_entities.user_entity_id%TYPE;
122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;

Line 126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;

122: g_ni_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;

Line 127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;

123: g_ni_earnings_eid ff_user_entities.user_entity_id%TYPE;
124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08

Line 128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;

124: g_ni_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;

Line 129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;

125: g_ni_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;

Line 130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;

126: g_ni_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;

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

127: g_ni_scon_ees_rebate_eid ff_user_entities.user_entity_id%TYPE;
128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;

Line 132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;

128: g_ni_scon_able_et_eid ff_user_entities.user_entity_id%TYPE;
129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;

Line 133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;

129: g_ni_scon_able_lel_eid ff_user_entities.user_entity_id%TYPE;
130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;

Line 134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;

130: g_ni_scon_able_uel_eid ff_user_entities.user_entity_id%TYPE;
131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;

Line 135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;

131: g_ni_scon_able_auel_eid ff_user_entities.user_entity_id%TYPE; --EOY 07/08
132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;

Line 136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;

132: g_ni_scon_earnings_eid ff_user_entities.user_entity_id%TYPE;
133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;

Line 137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;

133: g_ni_scon_ees_contribution_eid ff_user_entities.user_entity_id%TYPE;
134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

Line 138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;

134: g_ni_scon_ers_rebate_eid ff_user_entities.user_entity_id%TYPE;
135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;

Line 139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;

135: g_ni_scon_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;

Line 140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;

136: g_ni_tot_contribution_eid ff_user_entities.user_entity_id%TYPE;
137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

137: g_ni_refund_eid ff_user_entities.user_entity_id%TYPE;
138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;

Line 142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;

138: g_ni_scon_refund_eid ff_user_entities.user_entity_id%TYPE;
139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;

Line 143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;

139: g_organization_id_eid ff_user_entities.user_entity_id%TYPE;
140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;

Line 144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;

140: g_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;

Line 145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;

141: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;

142: g_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;

143: g_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
151: g_sex_eid ff_user_entities.user_entity_id%TYPE;

Line 148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;

144: g_pensioner_indicator_eid ff_user_entities.user_entity_id%TYPE;
145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
151: g_sex_eid ff_user_entities.user_entity_id%TYPE;
152: g_smp_eid ff_user_entities.user_entity_id%TYPE;

Line 149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

145: g_people_group_id_eid ff_user_entities.user_entity_id%TYPE;
146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
151: g_sex_eid ff_user_entities.user_entity_id%TYPE;
152: g_smp_eid ff_user_entities.user_entity_id%TYPE;
153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;

Line 150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

146: g_permit_number_eid ff_user_entities.user_entity_id%TYPE;
147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
151: g_sex_eid ff_user_entities.user_entity_id%TYPE;
152: g_smp_eid ff_user_entities.user_entity_id%TYPE;
153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
154: g_sap_eid ff_user_entities.user_entity_id%TYPE;

Line 151: g_sex_eid ff_user_entities.user_entity_id%TYPE;

147: g_person_id_eid ff_user_entities.user_entity_id%TYPE;
148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
151: g_sex_eid ff_user_entities.user_entity_id%TYPE;
152: g_smp_eid ff_user_entities.user_entity_id%TYPE;
153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
154: g_sap_eid ff_user_entities.user_entity_id%TYPE;
155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;

Line 152: g_smp_eid ff_user_entities.user_entity_id%TYPE;

148: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
151: g_sex_eid ff_user_entities.user_entity_id%TYPE;
152: g_smp_eid ff_user_entities.user_entity_id%TYPE;
153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
154: g_sap_eid ff_user_entities.user_entity_id%TYPE;
155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;

Line 153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;

149: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
151: g_sex_eid ff_user_entities.user_entity_id%TYPE;
152: g_smp_eid ff_user_entities.user_entity_id%TYPE;
153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
154: g_sap_eid ff_user_entities.user_entity_id%TYPE;
155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;

Line 154: g_sap_eid ff_user_entities.user_entity_id%TYPE;

150: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
151: g_sex_eid ff_user_entities.user_entity_id%TYPE;
152: g_smp_eid ff_user_entities.user_entity_id%TYPE;
153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
154: g_sap_eid ff_user_entities.user_entity_id%TYPE;
155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;

151: g_sex_eid ff_user_entities.user_entity_id%TYPE;
152: g_smp_eid ff_user_entities.user_entity_id%TYPE;
153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
154: g_sap_eid ff_user_entities.user_entity_id%TYPE;
155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;

Line 156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;

152: g_smp_eid ff_user_entities.user_entity_id%TYPE;
153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
154: g_sap_eid ff_user_entities.user_entity_id%TYPE;
155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;

Line 157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;

153: g_ssp_eid ff_user_entities.user_entity_id%TYPE;
154: g_sap_eid ff_user_entities.user_entity_id%TYPE;
155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;

Line 158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;

154: g_sap_eid ff_user_entities.user_entity_id%TYPE;
155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;

155: g_spp_adopt_eid ff_user_entities.user_entity_id%TYPE;
156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;

Line 160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;

156: g_spp_birth_eid ff_user_entities.user_entity_id%TYPE;
157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;

Line 161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;

157: g_start_of_emp_eid ff_user_entities.user_entity_id%TYPE;
158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;

Line 162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

158: g_superannuation_paid_eid ff_user_entities.user_entity_id%TYPE;
159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;

Line 163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;

159: g_superannuation_refund_eid ff_user_entities.user_entity_id%TYPE;
160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;

160: g_tax_dist_ref_eid ff_user_entities.user_entity_id%TYPE;
161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;

Line 165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;

161: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;

Line 166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;

162: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
170: g_title_eid ff_user_entities.user_entity_id%TYPE;

Line 167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

163: g_tax_ref_eid ff_user_entities.user_entity_id%TYPE;
164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
170: g_title_eid ff_user_entities.user_entity_id%TYPE;
171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;

Line 168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;

164: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
170: g_title_eid ff_user_entities.user_entity_id%TYPE;
171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;

165: g_tax_refund_eid ff_user_entities.user_entity_id%TYPE;
166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
170: g_title_eid ff_user_entities.user_entity_id%TYPE;
171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 170: g_title_eid ff_user_entities.user_entity_id%TYPE;

166: g_tax_run_result_id_eid ff_user_entities.user_entity_id%TYPE;
167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
170: g_title_eid ff_user_entities.user_entity_id%TYPE;
171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;

Line 171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;

167: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
170: g_title_eid ff_user_entities.user_entity_id%TYPE;
171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;

Line 172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;

168: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
170: g_title_eid ff_user_entities.user_entity_id%TYPE;
171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;

Line 173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;

169: g_termination_type_eid ff_user_entities.user_entity_id%TYPE;
170: g_title_eid ff_user_entities.user_entity_id%TYPE;
171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;

Line 174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;

170: g_title_eid ff_user_entities.user_entity_id%TYPE;
171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
178: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;

Line 175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;

171: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
178: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
179: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;

Line 176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;

172: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
178: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
179: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
180: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;

Line 177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;

173: g_week_53_indicator_eid ff_user_entities.user_entity_id%TYPE;
174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
178: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
179: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
180: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;
181: --

Line 178: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;

174: g_widows_and_orphans_eid ff_user_entities.user_entity_id%TYPE;
175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
178: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
179: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
180: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;
181: --
182: -- start/end year cache globals initialised in cache_archive_value:

Line 179: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;

175: g_student_loans_eid ff_user_entities.user_entity_id%TYPE;
176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
178: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
179: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
180: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;
181: --
182: -- start/end year cache globals initialised in cache_archive_value:
183: g_min_start_year DATE;

Line 180: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;

176: g_assignment_message_eid ff_user_entities.user_entity_id%TYPE;
177: g_ni_arrears_eid ff_user_entities.user_entity_id%TYPE;
178: g_reportable_ni_eid ff_user_entities.user_entity_id%TYPE;
179: g_agg_active_start_eid ff_user_entities.user_entity_id%TYPE;
180: g_agg_active_end_eid ff_user_entities.user_entity_id%TYPE;
181: --
182: -- start/end year cache globals initialised in cache_archive_value:
183: g_min_start_year DATE;
184: g_max_end_year DATE;

Line 497: l_user_entity_id ff_user_entities.user_entity_id%type;

493: -- two additional contexts. No validation is performed on the input
494: -- parameters. If a matching item does not exist, null is returned.
495: -- The additional context parameters must be populated in order.
496: IS
497: l_user_entity_id ff_user_entities.user_entity_id%type;
498: l_arch_value ff_archive_items.value%type;
499: BEGIN
500: SELECT fue.user_entity_id
501: INTO l_user_entity_id

Line 502: FROM ff_user_entities fue

498: l_arch_value ff_archive_items.value%type;
499: BEGIN
500: SELECT fue.user_entity_id
501: INTO l_user_entity_id
502: FROM ff_user_entities fue
503: WHERE fue.user_entity_name = p_user_entity_name
504: AND fue.legislation_code= 'GB';
505: --
506: l_arch_value := pay_gb_eoy_archive.get_arch_str(p_action_id,

Line 1237: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

1233: l_payroll_period_type VARCHAR2(30);
1234: l_payroll_max_period_number NUMBER;
1235: l_dummy NUMBER;
1236: -- User Entity IDs
1237: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1238: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1239: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;

Line 1238: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;

1234: l_payroll_max_period_number NUMBER;
1235: l_dummy NUMBER;
1236: -- User Entity IDs
1237: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1238: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1239: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;

Line 1239: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;

1235: l_dummy NUMBER;
1236: -- User Entity IDs
1237: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1238: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1239: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1243: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;

Line 1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;

1236: -- User Entity IDs
1237: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1238: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1239: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1243: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1244: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;

Line 1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;

1237: l_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
1238: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1239: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1243: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1244: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1245: l_econ_eid ff_user_entities.user_entity_id%TYPE;

Line 1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;

1238: l_permit_number_eid ff_user_entities.user_entity_id%TYPE;
1239: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1243: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1244: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1245: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1246:

Line 1243: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;

1239: l_payroll_name_eid ff_user_entities.user_entity_id%TYPE;
1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1243: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1244: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1245: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1246:
1247: /* Start 4011263

Line 1244: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;

1240: l_tax_district_reference_eid ff_user_entities.user_entity_id%TYPE;
1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1243: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1244: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1245: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1246:
1247: /* Start 4011263
1248: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;

Line 1245: l_econ_eid ff_user_entities.user_entity_id%TYPE;

1241: l_tax_reference_eid ff_user_entities.user_entity_id%TYPE;
1242: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1243: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1244: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1245: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1246:
1247: /* Start 4011263
1248: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1249: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;

Line 1248: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;

1244: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1245: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1246:
1247: /* Start 4011263
1248: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1249: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1250: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1251: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1252: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;

Line 1249: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;

1245: l_econ_eid ff_user_entities.user_entity_id%TYPE;
1246:
1247: /* Start 4011263
1248: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1249: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1250: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1251: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1252: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1253: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;

Line 1250: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;

1246:
1247: /* Start 4011263
1248: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1249: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1250: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1251: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1252: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1253: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1254: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;

Line 1251: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;

1247: /* Start 4011263
1248: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1249: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1250: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1251: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1252: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1253: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1254: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1255: End 4011263 */

Line 1252: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;

1248: l_smp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1249: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1250: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1251: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1252: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1253: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1254: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1255: End 4011263 */
1256:

Line 1253: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;

1249: l_sap_recovered_eid ff_user_entities.user_entity_id%TYPE;
1250: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1251: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1252: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1253: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1254: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1255: End 4011263 */
1256:
1257: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;

Line 1254: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;

1250: l_spp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1251: l_ssp_recovered_eid ff_user_entities.user_entity_id%TYPE;
1252: l_smp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1253: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1254: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1255: End 4011263 */
1256:
1257: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1258: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;

Line 1257: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;

1253: l_sap_compensation_eid ff_user_entities.user_entity_id%TYPE;
1254: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1255: End 4011263 */
1256:
1257: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1258: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1259: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1260: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1261: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;

Line 1258: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;

1254: l_spp_compensation_eid ff_user_entities.user_entity_id%TYPE;
1255: End 4011263 */
1256:
1257: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1258: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1259: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1260: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1261: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;
1262: -- exceptions

Line 1259: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;

1255: End 4011263 */
1256:
1257: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1258: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1259: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1260: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1261: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;
1262: -- exceptions
1263: tax_dist_ref_error EXCEPTION; -- raised when l_tax_district_reference

Line 1260: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;

1256:
1257: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1258: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1259: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1260: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1261: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;
1262: -- exceptions
1263: tax_dist_ref_error EXCEPTION; -- raised when l_tax_district_reference
1264: -- has incorrect format

Line 1261: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;

1257: l_payroll_start_year_eid ff_user_entities.user_entity_id%TYPE;
1258: l_payroll_end_year_eid ff_user_entities.user_entity_id%TYPE;
1259: l_payroll_period_type_eid ff_user_entities.user_entity_id%TYPE;
1260: l_max_period_number_eid ff_user_entities.user_entity_id%TYPE;
1261: l_payroll_action_message_eid ff_user_entities.user_entity_id%TYPE;
1262: -- exceptions
1263: tax_dist_ref_error EXCEPTION; -- raised when l_tax_district_reference
1264: -- has incorrect format
1265: inconsis_ref_error EXCEPTION; -- raised when a payroll has more than

Line 1368: FROM ff_user_entities

1364: AND p_end_year;
1365: --
1366: cursor csr_user_entity(p_entity_name VARCHAR2) IS
1367: SELECT user_entity_id
1368: FROM ff_user_entities
1369: WHERE user_entity_name = p_entity_name
1370: AND legislation_code = 'GB'
1371: AND business_group_id IS NULL;
1372: --

Line 1731: FROM ff_user_entities

1727: WHERE payroll_action_id = p_payroll_action_id;
1728: --
1729: cursor csr_user_entity(p_entity_name VARCHAR2) IS
1730: SELECT user_entity_id
1731: FROM ff_user_entities
1732: WHERE user_entity_name = p_entity_name
1733: AND legislation_code = 'GB'
1734: AND business_group_id IS NULL;
1735: --

Line 2244: FROM ff_user_entities

2240: WHERE payroll_action_id = p_payroll_action_id;
2241: --
2242: cursor csr_user_entity(p_entity_name VARCHAR2) IS
2243: SELECT user_entity_id
2244: FROM ff_user_entities
2245: WHERE user_entity_name = p_entity_name
2246: AND legislation_code = 'GB'
2247: AND business_group_id IS NULL;
2248: --

Line 2271: ff_user_entities fue,

2267: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2268: aic.context) tax_dist
2269: FROM ff_archive_item_contexts aic, /* payrolls */
2270: ff_archive_items fai, /* X_START_YEAR */
2271: ff_user_entities fue,
2272: pay_payroll_actions pact
2273: WHERE pact.report_type = 'EOY'
2274: AND pact.report_qualifier = 'GB'
2275: AND pact.action_type = 'X'

Line 3755: FROM ff_user_entities fue,

3751: -- X_P45_FINAL_PAYMENT_ACTION user entity
3752: --
3753: CURSOR csr_get_final_payment_date(c_asg_action_id NUMBER) IS
3754: SELECT ppa.effective_date
3755: FROM ff_user_entities fue,
3756: ff_archive_items fai,
3757: pay_assignment_actions paa,
3758: pay_payroll_actions ppa
3759: WHERE fue.user_entity_name = 'X_P45_FINAL_PAYMENT_ACTION'

Line 6054: FROM ff_user_entities

6050: -- is specific to Extract Items.
6051: --
6052: cursor csr_get_user_entity_id(c_user_entity_name VARCHAR2) IS
6053: SELECT user_entity_id
6054: FROM ff_user_entities
6055: WHERE user_entity_name = c_user_entity_name;
6056: --
6057: l_user_entity_id NUMBER;
6058: invalid_archive_type EXCEPTION;