DBA Data[Home] [Help]

APPS.BEN_EXT_CHLG dependencies on PER_ALL_ASSIGNMENTS_F

Line 175: (assignment_id per_all_assignments_f.assignment_id%type

171: ,date_to per_addresses.date_to%type
172: );
173: --
174: Type g_asg_rec_type is RECORD
175: (assignment_id per_all_assignments_f.assignment_id%type
176: ,person_id per_all_assignments_f.person_id%type
177: ,business_group_id per_all_assignments_f.business_group_id%type
178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type

Line 176: ,person_id per_all_assignments_f.person_id%type

172: );
173: --
174: Type g_asg_rec_type is RECORD
175: (assignment_id per_all_assignments_f.assignment_id%type
176: ,person_id per_all_assignments_f.person_id%type
177: ,business_group_id per_all_assignments_f.business_group_id%type
178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477

Line 177: ,business_group_id per_all_assignments_f.business_group_id%type

173: --
174: Type g_asg_rec_type is RECORD
175: (assignment_id per_all_assignments_f.assignment_id%type
176: ,person_id per_all_assignments_f.person_id%type
177: ,business_group_id per_all_assignments_f.business_group_id%type
178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181: ,location_id per_all_assignments_f.location_id%type

Line 178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type

174: Type g_asg_rec_type is RECORD
175: (assignment_id per_all_assignments_f.assignment_id%type
176: ,person_id per_all_assignments_f.person_id%type
177: ,business_group_id per_all_assignments_f.business_group_id%type
178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181: ,location_id per_all_assignments_f.location_id%type
182: ,position_id per_all_assignments_f.position_id%type

Line 179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type

175: (assignment_id per_all_assignments_f.assignment_id%type
176: ,person_id per_all_assignments_f.person_id%type
177: ,business_group_id per_all_assignments_f.business_group_id%type
178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181: ,location_id per_all_assignments_f.location_id%type
182: ,position_id per_all_assignments_f.position_id%type
183: ,employment_category per_all_assignments_f.employment_category%type

Line 180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477

176: ,person_id per_all_assignments_f.person_id%type
177: ,business_group_id per_all_assignments_f.business_group_id%type
178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181: ,location_id per_all_assignments_f.location_id%type
182: ,position_id per_all_assignments_f.position_id%type
183: ,employment_category per_all_assignments_f.employment_category%type
184: ,assignment_type per_all_assignments_f.assignment_type%type

Line 181: ,location_id per_all_assignments_f.location_id%type

177: ,business_group_id per_all_assignments_f.business_group_id%type
178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181: ,location_id per_all_assignments_f.location_id%type
182: ,position_id per_all_assignments_f.position_id%type
183: ,employment_category per_all_assignments_f.employment_category%type
184: ,assignment_type per_all_assignments_f.assignment_type%type
185: ,effective_start_date per_all_assignments_f.effective_start_date%type

Line 182: ,position_id per_all_assignments_f.position_id%type

178: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type
179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181: ,location_id per_all_assignments_f.location_id%type
182: ,position_id per_all_assignments_f.position_id%type
183: ,employment_category per_all_assignments_f.employment_category%type
184: ,assignment_type per_all_assignments_f.assignment_type%type
185: ,effective_start_date per_all_assignments_f.effective_start_date%type
186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type

Line 183: ,employment_category per_all_assignments_f.employment_category%type

179: ,hourly_salaried_code per_all_assignments_f.hourly_salaried_code%type
180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181: ,location_id per_all_assignments_f.location_id%type
182: ,position_id per_all_assignments_f.position_id%type
183: ,employment_category per_all_assignments_f.employment_category%type
184: ,assignment_type per_all_assignments_f.assignment_type%type
185: ,effective_start_date per_all_assignments_f.effective_start_date%type
186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type

Line 184: ,assignment_type per_all_assignments_f.assignment_type%type

180: ,normal_hours per_all_assignments_f.normal_hours%type --Bug 1554477
181: ,location_id per_all_assignments_f.location_id%type
182: ,position_id per_all_assignments_f.position_id%type
183: ,employment_category per_all_assignments_f.employment_category%type
184: ,assignment_type per_all_assignments_f.assignment_type%type
185: ,effective_start_date per_all_assignments_f.effective_start_date%type
186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type

Line 185: ,effective_start_date per_all_assignments_f.effective_start_date%type

181: ,location_id per_all_assignments_f.location_id%type
182: ,position_id per_all_assignments_f.position_id%type
183: ,employment_category per_all_assignments_f.employment_category%type
184: ,assignment_type per_all_assignments_f.assignment_type%type
185: ,effective_start_date per_all_assignments_f.effective_start_date%type
186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type

Line 186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type

182: ,position_id per_all_assignments_f.position_id%type
183: ,employment_category per_all_assignments_f.employment_category%type
184: ,assignment_type per_all_assignments_f.assignment_type%type
185: ,effective_start_date per_all_assignments_f.effective_start_date%type
186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type

Line 187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type

183: ,employment_category per_all_assignments_f.employment_category%type
184: ,assignment_type per_all_assignments_f.assignment_type%type
185: ,effective_start_date per_all_assignments_f.effective_start_date%type
186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type

Line 188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type

184: ,assignment_type per_all_assignments_f.assignment_type%type
185: ,effective_start_date per_all_assignments_f.effective_start_date%type
186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type

Line 189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type

185: ,effective_start_date per_all_assignments_f.effective_start_date%type
186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type

Line 190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type

186: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type

Line 191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type

187: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type

Line 192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type

188: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
196: ,payroll_id per_all_assignments_f.payroll_id%type

Line 193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type

189: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
196: ,payroll_id per_all_assignments_f.payroll_id%type
197: ,grade_id per_all_assignments_f.grade_id%type

Line 194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type

190: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
196: ,payroll_id per_all_assignments_f.payroll_id%type
197: ,grade_id per_all_assignments_f.grade_id%type
198: --rpinjala

Line 195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type

191: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
196: ,payroll_id per_all_assignments_f.payroll_id%type
197: ,grade_id per_all_assignments_f.grade_id%type
198: --rpinjala
199: ,primary_flag per_all_assignments_f.primary_flag%TYPE

Line 196: ,payroll_id per_all_assignments_f.payroll_id%type

192: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
196: ,payroll_id per_all_assignments_f.payroll_id%type
197: ,grade_id per_all_assignments_f.grade_id%type
198: --rpinjala
199: ,primary_flag per_all_assignments_f.primary_flag%TYPE
200: --rpinjala

Line 197: ,grade_id per_all_assignments_f.grade_id%type

193: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
194: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
196: ,payroll_id per_all_assignments_f.payroll_id%type
197: ,grade_id per_all_assignments_f.grade_id%type
198: --rpinjala
199: ,primary_flag per_all_assignments_f.primary_flag%TYPE
200: --rpinjala
201: -- vjhanak

Line 199: ,primary_flag per_all_assignments_f.primary_flag%TYPE

195: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
196: ,payroll_id per_all_assignments_f.payroll_id%type
197: ,grade_id per_all_assignments_f.grade_id%type
198: --rpinjala
199: ,primary_flag per_all_assignments_f.primary_flag%TYPE
200: --rpinjala
201: -- vjhanak
202: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
203: -- vjhanak

Line 202: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

198: --rpinjala
199: ,primary_flag per_all_assignments_f.primary_flag%TYPE
200: --rpinjala
201: -- vjhanak
202: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
203: -- vjhanak
204: ,effective_end_date per_all_assignments_f.effective_end_date%type
205: ,update_mode varchar2(20)
206: );

Line 204: ,effective_end_date per_all_assignments_f.effective_end_date%type

200: --rpinjala
201: -- vjhanak
202: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
203: -- vjhanak
204: ,effective_end_date per_all_assignments_f.effective_end_date%type
205: ,update_mode varchar2(20)
206: );
207: --
208: Type g_pos_rec_type is RECORD