APPS.PER_QH_SUMMARY_QUERY dependencies on PER_ALL_ASSIGNMENTS_F

Line 20: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type

16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: --CWK
19: ,npw_number per_all_people_f.npw_number%type
20: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
21: ,projected_assignment_end per_all_assignments_f.projected_assignment_end%type
22: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
23: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
24: ,vendor_name po_vendors.vendor_name%type

Line 21: ,projected_assignment_end per_all_assignments_f.projected_assignment_end%type

17: ,corr_lang_meaning hr_lookups.meaning%type
18: --CWK
19: ,npw_number per_all_people_f.npw_number%type
20: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
21: ,projected_assignment_end per_all_assignments_f.projected_assignment_end%type
22: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
23: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
24: ,vendor_name po_vendors.vendor_name%type
25: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE

Line 22: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type

18: --CWK
19: ,npw_number per_all_people_f.npw_number%type
20: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
21: ,projected_assignment_end per_all_assignments_f.projected_assignment_end%type
22: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
23: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
24: ,vendor_name po_vendors.vendor_name%type
25: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE
26: ,po_header_num po_headers_all.segment1%TYPE

Line 23: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type

19: ,npw_number per_all_people_f.npw_number%type
20: ,period_of_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
21: ,projected_assignment_end per_all_assignments_f.projected_assignment_end%type
22: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
23: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
24: ,vendor_name po_vendors.vendor_name%type
25: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE
26: ,po_header_num po_headers_all.segment1%TYPE
27: ,po_line_num po_lines_all.line_num%TYPE

Line 28: ,project_title per_all_assignments_f.project_title%type

24: ,vendor_name po_vendors.vendor_name%type
25: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE
26: ,po_header_num po_headers_all.segment1%TYPE
27: ,po_line_num po_lines_all.line_num%TYPE
28: ,project_title per_all_assignments_f.project_title%type
29: --
30: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
31: ,date_of_birth per_all_people_f.date_of_birth%type
32: ,age number

Line 143: ,assignment_id per_all_assignments_f.assignment_id%type

139: ,region_of_birth_meaning per_all_people_f.region_of_birth%type
140: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
141: ,per_object_version_number number
142: ,person_update_allowed varchar2(5)
143: ,assignment_id per_all_assignments_f.assignment_id%type
144: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
145: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
146: ,recruiter per_all_people_f.full_name%type
147: ,grade per_grades.name%type

Line 144: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type

140: ,country_of_birth_meaning per_all_people_f.country_of_birth%type
141: ,per_object_version_number number
142: ,person_update_allowed varchar2(5)
143: ,assignment_id per_all_assignments_f.assignment_id%type
144: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
145: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
146: ,recruiter per_all_people_f.full_name%type
147: ,grade per_grades.name%type
148: ,grade_ladder ben_pgm_f.name%type

Line 145: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type

141: ,per_object_version_number number
142: ,person_update_allowed varchar2(5)
143: ,assignment_id per_all_assignments_f.assignment_id%type
144: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
145: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
146: ,recruiter per_all_people_f.full_name%type
147: ,grade per_grades.name%type
148: ,grade_ladder ben_pgm_f.name%type
149: ,position hr_all_positions_f.name%type

Line 190: ,people_group_id per_all_assignments_f.people_group_id%type

186: ,pgp_segment27 pay_people_groups.segment27%type
187: ,pgp_segment28 pay_people_groups.segment28%type
188: ,pgp_segment29 pay_people_groups.segment29%type
189: ,pgp_segment30 pay_people_groups.segment30%type
190: ,people_group_id per_all_assignments_f.people_group_id%type
191: ,scl_segment1 hr_soft_coding_keyflex.segment1%type
192: ,scl_segment2 hr_soft_coding_keyflex.segment2%type
193: ,scl_segment3 hr_soft_coding_keyflex.segment3%type
194: ,scl_segment4 hr_soft_coding_keyflex.segment4%type

Line 221: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type

217: ,scl_segment27 hr_soft_coding_keyflex.segment27%type
218: ,scl_segment28 hr_soft_coding_keyflex.segment28%type
219: ,scl_segment29 hr_soft_coding_keyflex.segment29%type
220: ,scl_segment30 hr_soft_coding_keyflex.segment30%type
221: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type
222: ,vacancy per_vacancies.name%type
223: ,requisition per_requisitions.name%type
224: ,salary_basis per_pay_bases.name%type
225: ,pay_basis per_pay_bases.pay_basis%type

Line 227: ,assignment_sequence per_all_assignments_f.assignment_sequence%type

223: ,requisition per_requisitions.name%type
224: ,salary_basis per_pay_bases.name%type
225: ,pay_basis per_pay_bases.pay_basis%type
226: ,pay_basis_meaning hr_lookups.meaning%type
227: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
228: ,assignment_type per_all_assignments_f.assignment_type%type
229: ,asg_primary_flag per_all_assignments_f.primary_flag%type
230: ,assignment_number per_all_assignments_f.assignment_number%type
231: ,date_probation_end per_all_assignments_f.date_probation_end%type

Line 228: ,assignment_type per_all_assignments_f.assignment_type%type

224: ,salary_basis per_pay_bases.name%type
225: ,pay_basis per_pay_bases.pay_basis%type
226: ,pay_basis_meaning hr_lookups.meaning%type
227: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
228: ,assignment_type per_all_assignments_f.assignment_type%type
229: ,asg_primary_flag per_all_assignments_f.primary_flag%type
230: ,assignment_number per_all_assignments_f.assignment_number%type
231: ,date_probation_end per_all_assignments_f.date_probation_end%type
232: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type

Line 229: ,asg_primary_flag per_all_assignments_f.primary_flag%type

225: ,pay_basis per_pay_bases.pay_basis%type
226: ,pay_basis_meaning hr_lookups.meaning%type
227: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
228: ,assignment_type per_all_assignments_f.assignment_type%type
229: ,asg_primary_flag per_all_assignments_f.primary_flag%type
230: ,assignment_number per_all_assignments_f.assignment_number%type
231: ,date_probation_end per_all_assignments_f.date_probation_end%type
232: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
233: ,employment_category_meaning hr_lookups.meaning%type

Line 230: ,assignment_number per_all_assignments_f.assignment_number%type

226: ,pay_basis_meaning hr_lookups.meaning%type
227: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
228: ,assignment_type per_all_assignments_f.assignment_type%type
229: ,asg_primary_flag per_all_assignments_f.primary_flag%type
230: ,assignment_number per_all_assignments_f.assignment_number%type
231: ,date_probation_end per_all_assignments_f.date_probation_end%type
232: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
233: ,employment_category_meaning hr_lookups.meaning%type
234: ,employee_category_meaning hr_lookups.meaning%type

Line 231: ,date_probation_end per_all_assignments_f.date_probation_end%type

227: ,assignment_sequence per_all_assignments_f.assignment_sequence%type
228: ,assignment_type per_all_assignments_f.assignment_type%type
229: ,asg_primary_flag per_all_assignments_f.primary_flag%type
230: ,assignment_number per_all_assignments_f.assignment_number%type
231: ,date_probation_end per_all_assignments_f.date_probation_end%type
232: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
233: ,employment_category_meaning hr_lookups.meaning%type
234: ,employee_category_meaning hr_lookups.meaning%type
235: ,frequency_meaning hr_lookups.meaning%type

Line 232: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type

228: ,assignment_type per_all_assignments_f.assignment_type%type
229: ,asg_primary_flag per_all_assignments_f.primary_flag%type
230: ,assignment_number per_all_assignments_f.assignment_number%type
231: ,date_probation_end per_all_assignments_f.date_probation_end%type
232: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
233: ,employment_category_meaning hr_lookups.meaning%type
234: ,employee_category_meaning hr_lookups.meaning%type
235: ,frequency_meaning hr_lookups.meaning%type
236: ,normal_hours per_all_assignments_f.normal_hours%type

Line 236: ,normal_hours per_all_assignments_f.normal_hours%type

232: ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
233: ,employment_category_meaning hr_lookups.meaning%type
234: ,employee_category_meaning hr_lookups.meaning%type
235: ,frequency_meaning hr_lookups.meaning%type
236: ,normal_hours per_all_assignments_f.normal_hours%type
237: ,probation_period per_all_assignments_f.probation_period%type
238: ,probation_unit_meaning hr_lookups.meaning%type
239: ,notice_period per_all_assignments_f.notice_period%type
240: ,notice_unit_meaning hr_lookups.meaning%type

Line 237: ,probation_period per_all_assignments_f.probation_period%type

233: ,employment_category_meaning hr_lookups.meaning%type
234: ,employee_category_meaning hr_lookups.meaning%type
235: ,frequency_meaning hr_lookups.meaning%type
236: ,normal_hours per_all_assignments_f.normal_hours%type
237: ,probation_period per_all_assignments_f.probation_period%type
238: ,probation_unit_meaning hr_lookups.meaning%type
239: ,notice_period per_all_assignments_f.notice_period%type
240: ,notice_unit_meaning hr_lookups.meaning%type
241: ,time_normal_finish per_all_assignments_f.time_normal_finish%type

Line 239: ,notice_period per_all_assignments_f.notice_period%type

235: ,frequency_meaning hr_lookups.meaning%type
236: ,normal_hours per_all_assignments_f.normal_hours%type
237: ,probation_period per_all_assignments_f.probation_period%type
238: ,probation_unit_meaning hr_lookups.meaning%type
239: ,notice_period per_all_assignments_f.notice_period%type
240: ,notice_unit_meaning hr_lookups.meaning%type
241: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
242: ,time_normal_start per_all_assignments_f.time_normal_start%type
243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type

Line 241: ,time_normal_finish per_all_assignments_f.time_normal_finish%type

237: ,probation_period per_all_assignments_f.probation_period%type
238: ,probation_unit_meaning hr_lookups.meaning%type
239: ,notice_period per_all_assignments_f.notice_period%type
240: ,notice_unit_meaning hr_lookups.meaning%type
241: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
242: ,time_normal_start per_all_assignments_f.time_normal_start%type
243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type

Line 242: ,time_normal_start per_all_assignments_f.time_normal_start%type

238: ,probation_unit_meaning hr_lookups.meaning%type
239: ,notice_period per_all_assignments_f.notice_period%type
240: ,notice_unit_meaning hr_lookups.meaning%type
241: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
242: ,time_normal_start per_all_assignments_f.time_normal_start%type
243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type

Line 243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type

239: ,notice_period per_all_assignments_f.notice_period%type
240: ,notice_unit_meaning hr_lookups.meaning%type
241: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
242: ,time_normal_start per_all_assignments_f.time_normal_start%type
243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type

Line 244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type

240: ,notice_unit_meaning hr_lookups.meaning%type
241: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
242: ,time_normal_start per_all_assignments_f.time_normal_start%type
243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type

Line 245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type

241: ,time_normal_finish per_all_assignments_f.time_normal_finish%type
242: ,time_normal_start per_all_assignments_f.time_normal_start%type
243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type

Line 246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type

242: ,time_normal_start per_all_assignments_f.time_normal_start%type
243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type

Line 247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type

243: ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type

Line 248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type

244: ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type

Line 249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type

245: ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type

Line 250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type

246: ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type

Line 251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type

247: ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type

Line 252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type

248: ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type

Line 253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type

249: ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type

Line 254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type

250: ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type

Line 255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type

251: ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type

Line 256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type

252: ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type

Line 257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type

253: ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type

Line 258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type

254: ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type

Line 259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type

255: ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type

Line 260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type

256: ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type

Line 261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type

257: ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type

Line 262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type

258: ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type

Line 263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type

259: ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type

Line 264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type

260: ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type

Line 265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type

261: ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type

Line 266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type

262: ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type

Line 267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type

263: ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type

Line 268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type

264: ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
272: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type

Line 269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type

265: ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
272: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
273: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type

Line 270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type

266: ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
272: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
273: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
274: ,bargaining_unit_code_meaning hr_lookups.meaning%type

Line 271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type

267: ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
272: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
273: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
274: ,bargaining_unit_code_meaning hr_lookups.meaning%type
275: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type

Line 272: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type

268: ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
272: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
273: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
274: ,bargaining_unit_code_meaning hr_lookups.meaning%type
275: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type
276: ,hourly_salaried_meaning hr_lookups.meaning%type

Line 273: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type

269: ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
270: ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
272: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
273: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
274: ,bargaining_unit_code_meaning hr_lookups.meaning%type
275: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type
276: ,hourly_salaried_meaning hr_lookups.meaning%type
277: ,special_ceiling_step number

Line 275: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type

271: ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
272: ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
273: ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
274: ,bargaining_unit_code_meaning hr_lookups.meaning%type
275: ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type
276: ,hourly_salaried_meaning hr_lookups.meaning%type
277: ,special_ceiling_step number
278: ,special_ceiling_point per_spinal_points.spinal_point%type
279: ,change_reason_meaning hr_lookups.meaning%type

Line 280: ,internal_address_line per_all_assignments_f.internal_address_line%type

276: ,hourly_salaried_meaning hr_lookups.meaning%type
277: ,special_ceiling_step number
278: ,special_ceiling_point per_spinal_points.spinal_point%type
279: ,change_reason_meaning hr_lookups.meaning%type
280: ,internal_address_line per_all_assignments_f.internal_address_line%type
281: ,manager_flag per_all_assignments_f.manager_flag%type
282: ,perf_review_period per_all_assignments_f.perf_review_period%type
283: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
284: ,sal_review_period per_all_assignments_f.sal_review_period%type

Line 281: ,manager_flag per_all_assignments_f.manager_flag%type

277: ,special_ceiling_step number
278: ,special_ceiling_point per_spinal_points.spinal_point%type
279: ,change_reason_meaning hr_lookups.meaning%type
280: ,internal_address_line per_all_assignments_f.internal_address_line%type
281: ,manager_flag per_all_assignments_f.manager_flag%type
282: ,perf_review_period per_all_assignments_f.perf_review_period%type
283: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
284: ,sal_review_period per_all_assignments_f.sal_review_period%type
285: ,sal_rev_period_freq_meaning hr_lookups.meaning%type

Line 282: ,perf_review_period per_all_assignments_f.perf_review_period%type

278: ,special_ceiling_point per_spinal_points.spinal_point%type
279: ,change_reason_meaning hr_lookups.meaning%type
280: ,internal_address_line per_all_assignments_f.internal_address_line%type
281: ,manager_flag per_all_assignments_f.manager_flag%type
282: ,perf_review_period per_all_assignments_f.perf_review_period%type
283: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
284: ,sal_review_period per_all_assignments_f.sal_review_period%type
285: ,sal_rev_period_freq_meaning hr_lookups.meaning%type
286: ,source_type_meaning hr_lookups.meaning%type

Line 284: ,sal_review_period per_all_assignments_f.sal_review_period%type

280: ,internal_address_line per_all_assignments_f.internal_address_line%type
281: ,manager_flag per_all_assignments_f.manager_flag%type
282: ,perf_review_period per_all_assignments_f.perf_review_period%type
283: ,perf_rev_period_freq_meaning hr_lookups.meaning%type
284: ,sal_review_period per_all_assignments_f.sal_review_period%type
285: ,sal_rev_period_freq_meaning hr_lookups.meaning%type
286: ,source_type_meaning hr_lookups.meaning%type
287: ,contract per_contracts_f.reference%type
288: ,collective_agreement per_collective_agreements.name%type

Line 290: ,cagr_id_flex_num per_all_assignments_f.cagr_id_flex_num%type

286: ,source_type_meaning hr_lookups.meaning%type
287: ,contract per_contracts_f.reference%type
288: ,collective_agreement per_collective_agreements.name%type
289: -- Bug 4003788
290: ,cagr_id_flex_num per_all_assignments_f.cagr_id_flex_num%type
291: ,cagr_id_flex_name fnd_id_flex_structures_v.id_flex_structure_name%type
292: ,cagr_grade varchar2(150)
293: ,cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%type
294: --Bug 4003788

Line 293: ,cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%type

289: -- Bug 4003788
290: ,cagr_id_flex_num per_all_assignments_f.cagr_id_flex_num%type
291: ,cagr_id_flex_name fnd_id_flex_structures_v.id_flex_structure_name%type
292: ,cagr_grade varchar2(150)
293: ,cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%type
294: --Bug 4003788
295: ,establishment per_establishments.name%type
296: ,asg_object_version_number number
297: ,asg_update_allowed varchar2(5)