APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_APPLICATIONS

Line 375: ,application_id per_applications.application_id%type

371: ,asg_update_allowed varchar2(5)
372: --Bug 3063591 Start Here
373: ,work_at_home per_all_assignments_f.work_at_home%type default null
374: --Bug 3063591 End Here
375: ,application_id per_applications.application_id%type
376: ,projected_hire_date per_applications.projected_hire_date%type
377: ,appl_attribute_category per_applications.appl_attribute_category%type
378: ,appl_attribute1 per_applications.appl_attribute1%type
379: ,appl_attribute2 per_applications.appl_attribute2%type

Line 376: ,projected_hire_date per_applications.projected_hire_date%type

372: --Bug 3063591 Start Here
373: ,work_at_home per_all_assignments_f.work_at_home%type default null
374: --Bug 3063591 End Here
375: ,application_id per_applications.application_id%type
376: ,projected_hire_date per_applications.projected_hire_date%type
377: ,appl_attribute_category per_applications.appl_attribute_category%type
378: ,appl_attribute1 per_applications.appl_attribute1%type
379: ,appl_attribute2 per_applications.appl_attribute2%type
380: ,appl_attribute3 per_applications.appl_attribute3%type

Line 377: ,appl_attribute_category per_applications.appl_attribute_category%type

373: ,work_at_home per_all_assignments_f.work_at_home%type default null
374: --Bug 3063591 End Here
375: ,application_id per_applications.application_id%type
376: ,projected_hire_date per_applications.projected_hire_date%type
377: ,appl_attribute_category per_applications.appl_attribute_category%type
378: ,appl_attribute1 per_applications.appl_attribute1%type
379: ,appl_attribute2 per_applications.appl_attribute2%type
380: ,appl_attribute3 per_applications.appl_attribute3%type
381: ,appl_attribute4 per_applications.appl_attribute4%type

Line 378: ,appl_attribute1 per_applications.appl_attribute1%type

374: --Bug 3063591 End Here
375: ,application_id per_applications.application_id%type
376: ,projected_hire_date per_applications.projected_hire_date%type
377: ,appl_attribute_category per_applications.appl_attribute_category%type
378: ,appl_attribute1 per_applications.appl_attribute1%type
379: ,appl_attribute2 per_applications.appl_attribute2%type
380: ,appl_attribute3 per_applications.appl_attribute3%type
381: ,appl_attribute4 per_applications.appl_attribute4%type
382: ,appl_attribute5 per_applications.appl_attribute5%type

Line 379: ,appl_attribute2 per_applications.appl_attribute2%type

375: ,application_id per_applications.application_id%type
376: ,projected_hire_date per_applications.projected_hire_date%type
377: ,appl_attribute_category per_applications.appl_attribute_category%type
378: ,appl_attribute1 per_applications.appl_attribute1%type
379: ,appl_attribute2 per_applications.appl_attribute2%type
380: ,appl_attribute3 per_applications.appl_attribute3%type
381: ,appl_attribute4 per_applications.appl_attribute4%type
382: ,appl_attribute5 per_applications.appl_attribute5%type
383: ,appl_attribute6 per_applications.appl_attribute6%type

Line 380: ,appl_attribute3 per_applications.appl_attribute3%type

376: ,projected_hire_date per_applications.projected_hire_date%type
377: ,appl_attribute_category per_applications.appl_attribute_category%type
378: ,appl_attribute1 per_applications.appl_attribute1%type
379: ,appl_attribute2 per_applications.appl_attribute2%type
380: ,appl_attribute3 per_applications.appl_attribute3%type
381: ,appl_attribute4 per_applications.appl_attribute4%type
382: ,appl_attribute5 per_applications.appl_attribute5%type
383: ,appl_attribute6 per_applications.appl_attribute6%type
384: ,appl_attribute7 per_applications.appl_attribute7%type

Line 381: ,appl_attribute4 per_applications.appl_attribute4%type

377: ,appl_attribute_category per_applications.appl_attribute_category%type
378: ,appl_attribute1 per_applications.appl_attribute1%type
379: ,appl_attribute2 per_applications.appl_attribute2%type
380: ,appl_attribute3 per_applications.appl_attribute3%type
381: ,appl_attribute4 per_applications.appl_attribute4%type
382: ,appl_attribute5 per_applications.appl_attribute5%type
383: ,appl_attribute6 per_applications.appl_attribute6%type
384: ,appl_attribute7 per_applications.appl_attribute7%type
385: ,appl_attribute8 per_applications.appl_attribute8%type

Line 382: ,appl_attribute5 per_applications.appl_attribute5%type

378: ,appl_attribute1 per_applications.appl_attribute1%type
379: ,appl_attribute2 per_applications.appl_attribute2%type
380: ,appl_attribute3 per_applications.appl_attribute3%type
381: ,appl_attribute4 per_applications.appl_attribute4%type
382: ,appl_attribute5 per_applications.appl_attribute5%type
383: ,appl_attribute6 per_applications.appl_attribute6%type
384: ,appl_attribute7 per_applications.appl_attribute7%type
385: ,appl_attribute8 per_applications.appl_attribute8%type
386: ,appl_attribute9 per_applications.appl_attribute9%type

Line 383: ,appl_attribute6 per_applications.appl_attribute6%type

379: ,appl_attribute2 per_applications.appl_attribute2%type
380: ,appl_attribute3 per_applications.appl_attribute3%type
381: ,appl_attribute4 per_applications.appl_attribute4%type
382: ,appl_attribute5 per_applications.appl_attribute5%type
383: ,appl_attribute6 per_applications.appl_attribute6%type
384: ,appl_attribute7 per_applications.appl_attribute7%type
385: ,appl_attribute8 per_applications.appl_attribute8%type
386: ,appl_attribute9 per_applications.appl_attribute9%type
387: ,appl_attribute10 per_applications.appl_attribute10%type

Line 384: ,appl_attribute7 per_applications.appl_attribute7%type

380: ,appl_attribute3 per_applications.appl_attribute3%type
381: ,appl_attribute4 per_applications.appl_attribute4%type
382: ,appl_attribute5 per_applications.appl_attribute5%type
383: ,appl_attribute6 per_applications.appl_attribute6%type
384: ,appl_attribute7 per_applications.appl_attribute7%type
385: ,appl_attribute8 per_applications.appl_attribute8%type
386: ,appl_attribute9 per_applications.appl_attribute9%type
387: ,appl_attribute10 per_applications.appl_attribute10%type
388: ,appl_attribute11 per_applications.appl_attribute11%type

Line 385: ,appl_attribute8 per_applications.appl_attribute8%type

381: ,appl_attribute4 per_applications.appl_attribute4%type
382: ,appl_attribute5 per_applications.appl_attribute5%type
383: ,appl_attribute6 per_applications.appl_attribute6%type
384: ,appl_attribute7 per_applications.appl_attribute7%type
385: ,appl_attribute8 per_applications.appl_attribute8%type
386: ,appl_attribute9 per_applications.appl_attribute9%type
387: ,appl_attribute10 per_applications.appl_attribute10%type
388: ,appl_attribute11 per_applications.appl_attribute11%type
389: ,appl_attribute12 per_applications.appl_attribute12%type

Line 386: ,appl_attribute9 per_applications.appl_attribute9%type

382: ,appl_attribute5 per_applications.appl_attribute5%type
383: ,appl_attribute6 per_applications.appl_attribute6%type
384: ,appl_attribute7 per_applications.appl_attribute7%type
385: ,appl_attribute8 per_applications.appl_attribute8%type
386: ,appl_attribute9 per_applications.appl_attribute9%type
387: ,appl_attribute10 per_applications.appl_attribute10%type
388: ,appl_attribute11 per_applications.appl_attribute11%type
389: ,appl_attribute12 per_applications.appl_attribute12%type
390: ,appl_attribute13 per_applications.appl_attribute13%type

Line 387: ,appl_attribute10 per_applications.appl_attribute10%type

383: ,appl_attribute6 per_applications.appl_attribute6%type
384: ,appl_attribute7 per_applications.appl_attribute7%type
385: ,appl_attribute8 per_applications.appl_attribute8%type
386: ,appl_attribute9 per_applications.appl_attribute9%type
387: ,appl_attribute10 per_applications.appl_attribute10%type
388: ,appl_attribute11 per_applications.appl_attribute11%type
389: ,appl_attribute12 per_applications.appl_attribute12%type
390: ,appl_attribute13 per_applications.appl_attribute13%type
391: ,appl_attribute14 per_applications.appl_attribute14%type

Line 388: ,appl_attribute11 per_applications.appl_attribute11%type

384: ,appl_attribute7 per_applications.appl_attribute7%type
385: ,appl_attribute8 per_applications.appl_attribute8%type
386: ,appl_attribute9 per_applications.appl_attribute9%type
387: ,appl_attribute10 per_applications.appl_attribute10%type
388: ,appl_attribute11 per_applications.appl_attribute11%type
389: ,appl_attribute12 per_applications.appl_attribute12%type
390: ,appl_attribute13 per_applications.appl_attribute13%type
391: ,appl_attribute14 per_applications.appl_attribute14%type
392: ,appl_attribute15 per_applications.appl_attribute15%type

Line 389: ,appl_attribute12 per_applications.appl_attribute12%type

385: ,appl_attribute8 per_applications.appl_attribute8%type
386: ,appl_attribute9 per_applications.appl_attribute9%type
387: ,appl_attribute10 per_applications.appl_attribute10%type
388: ,appl_attribute11 per_applications.appl_attribute11%type
389: ,appl_attribute12 per_applications.appl_attribute12%type
390: ,appl_attribute13 per_applications.appl_attribute13%type
391: ,appl_attribute14 per_applications.appl_attribute14%type
392: ,appl_attribute15 per_applications.appl_attribute15%type
393: ,appl_attribute16 per_applications.appl_attribute16%type

Line 390: ,appl_attribute13 per_applications.appl_attribute13%type

386: ,appl_attribute9 per_applications.appl_attribute9%type
387: ,appl_attribute10 per_applications.appl_attribute10%type
388: ,appl_attribute11 per_applications.appl_attribute11%type
389: ,appl_attribute12 per_applications.appl_attribute12%type
390: ,appl_attribute13 per_applications.appl_attribute13%type
391: ,appl_attribute14 per_applications.appl_attribute14%type
392: ,appl_attribute15 per_applications.appl_attribute15%type
393: ,appl_attribute16 per_applications.appl_attribute16%type
394: ,appl_attribute17 per_applications.appl_attribute17%type

Line 391: ,appl_attribute14 per_applications.appl_attribute14%type

387: ,appl_attribute10 per_applications.appl_attribute10%type
388: ,appl_attribute11 per_applications.appl_attribute11%type
389: ,appl_attribute12 per_applications.appl_attribute12%type
390: ,appl_attribute13 per_applications.appl_attribute13%type
391: ,appl_attribute14 per_applications.appl_attribute14%type
392: ,appl_attribute15 per_applications.appl_attribute15%type
393: ,appl_attribute16 per_applications.appl_attribute16%type
394: ,appl_attribute17 per_applications.appl_attribute17%type
395: ,appl_attribute18 per_applications.appl_attribute18%type

Line 392: ,appl_attribute15 per_applications.appl_attribute15%type

388: ,appl_attribute11 per_applications.appl_attribute11%type
389: ,appl_attribute12 per_applications.appl_attribute12%type
390: ,appl_attribute13 per_applications.appl_attribute13%type
391: ,appl_attribute14 per_applications.appl_attribute14%type
392: ,appl_attribute15 per_applications.appl_attribute15%type
393: ,appl_attribute16 per_applications.appl_attribute16%type
394: ,appl_attribute17 per_applications.appl_attribute17%type
395: ,appl_attribute18 per_applications.appl_attribute18%type
396: ,appl_attribute19 per_applications.appl_attribute19%type

Line 393: ,appl_attribute16 per_applications.appl_attribute16%type

389: ,appl_attribute12 per_applications.appl_attribute12%type
390: ,appl_attribute13 per_applications.appl_attribute13%type
391: ,appl_attribute14 per_applications.appl_attribute14%type
392: ,appl_attribute15 per_applications.appl_attribute15%type
393: ,appl_attribute16 per_applications.appl_attribute16%type
394: ,appl_attribute17 per_applications.appl_attribute17%type
395: ,appl_attribute18 per_applications.appl_attribute18%type
396: ,appl_attribute19 per_applications.appl_attribute19%type
397: ,appl_attribute20 per_applications.appl_attribute20%type

Line 394: ,appl_attribute17 per_applications.appl_attribute17%type

390: ,appl_attribute13 per_applications.appl_attribute13%type
391: ,appl_attribute14 per_applications.appl_attribute14%type
392: ,appl_attribute15 per_applications.appl_attribute15%type
393: ,appl_attribute16 per_applications.appl_attribute16%type
394: ,appl_attribute17 per_applications.appl_attribute17%type
395: ,appl_attribute18 per_applications.appl_attribute18%type
396: ,appl_attribute19 per_applications.appl_attribute19%type
397: ,appl_attribute20 per_applications.appl_attribute20%type
398: ,current_employer per_applications.current_employer%type

Line 395: ,appl_attribute18 per_applications.appl_attribute18%type

391: ,appl_attribute14 per_applications.appl_attribute14%type
392: ,appl_attribute15 per_applications.appl_attribute15%type
393: ,appl_attribute16 per_applications.appl_attribute16%type
394: ,appl_attribute17 per_applications.appl_attribute17%type
395: ,appl_attribute18 per_applications.appl_attribute18%type
396: ,appl_attribute19 per_applications.appl_attribute19%type
397: ,appl_attribute20 per_applications.appl_attribute20%type
398: ,current_employer per_applications.current_employer%type
399: ,successful_flag per_applications.successful_flag%type

Line 396: ,appl_attribute19 per_applications.appl_attribute19%type

392: ,appl_attribute15 per_applications.appl_attribute15%type
393: ,appl_attribute16 per_applications.appl_attribute16%type
394: ,appl_attribute17 per_applications.appl_attribute17%type
395: ,appl_attribute18 per_applications.appl_attribute18%type
396: ,appl_attribute19 per_applications.appl_attribute19%type
397: ,appl_attribute20 per_applications.appl_attribute20%type
398: ,current_employer per_applications.current_employer%type
399: ,successful_flag per_applications.successful_flag%type
400: ,termination_reason per_applications.termination_reason%type

Line 397: ,appl_attribute20 per_applications.appl_attribute20%type

393: ,appl_attribute16 per_applications.appl_attribute16%type
394: ,appl_attribute17 per_applications.appl_attribute17%type
395: ,appl_attribute18 per_applications.appl_attribute18%type
396: ,appl_attribute19 per_applications.appl_attribute19%type
397: ,appl_attribute20 per_applications.appl_attribute20%type
398: ,current_employer per_applications.current_employer%type
399: ,successful_flag per_applications.successful_flag%type
400: ,termination_reason per_applications.termination_reason%type
401: ,termination_reason_meaning hr_lookups.meaning%type

Line 398: ,current_employer per_applications.current_employer%type

394: ,appl_attribute17 per_applications.appl_attribute17%type
395: ,appl_attribute18 per_applications.appl_attribute18%type
396: ,appl_attribute19 per_applications.appl_attribute19%type
397: ,appl_attribute20 per_applications.appl_attribute20%type
398: ,current_employer per_applications.current_employer%type
399: ,successful_flag per_applications.successful_flag%type
400: ,termination_reason per_applications.termination_reason%type
401: ,termination_reason_meaning hr_lookups.meaning%type
402: ,app_date_received per_applications.date_received%type

Line 399: ,successful_flag per_applications.successful_flag%type

395: ,appl_attribute18 per_applications.appl_attribute18%type
396: ,appl_attribute19 per_applications.appl_attribute19%type
397: ,appl_attribute20 per_applications.appl_attribute20%type
398: ,current_employer per_applications.current_employer%type
399: ,successful_flag per_applications.successful_flag%type
400: ,termination_reason per_applications.termination_reason%type
401: ,termination_reason_meaning hr_lookups.meaning%type
402: ,app_date_received per_applications.date_received%type
403: ,app_date_end per_applications.date_end%type

Line 400: ,termination_reason per_applications.termination_reason%type

396: ,appl_attribute19 per_applications.appl_attribute19%type
397: ,appl_attribute20 per_applications.appl_attribute20%type
398: ,current_employer per_applications.current_employer%type
399: ,successful_flag per_applications.successful_flag%type
400: ,termination_reason per_applications.termination_reason%type
401: ,termination_reason_meaning hr_lookups.meaning%type
402: ,app_date_received per_applications.date_received%type
403: ,app_date_end per_applications.date_end%type
404: ,app_object_version_number per_applications.object_version_number%type

Line 402: ,app_date_received per_applications.date_received%type

398: ,current_employer per_applications.current_employer%type
399: ,successful_flag per_applications.successful_flag%type
400: ,termination_reason per_applications.termination_reason%type
401: ,termination_reason_meaning hr_lookups.meaning%type
402: ,app_date_received per_applications.date_received%type
403: ,app_date_end per_applications.date_end%type
404: ,app_object_version_number per_applications.object_version_number%type
405: ,adjusted_svc_date per_periods_of_service.adjusted_svc_date%type
406: ,employment_end_date per_periods_of_service.final_process_date%type

Line 403: ,app_date_end per_applications.date_end%type

399: ,successful_flag per_applications.successful_flag%type
400: ,termination_reason per_applications.termination_reason%type
401: ,termination_reason_meaning hr_lookups.meaning%type
402: ,app_date_received per_applications.date_received%type
403: ,app_date_end per_applications.date_end%type
404: ,app_object_version_number per_applications.object_version_number%type
405: ,adjusted_svc_date per_periods_of_service.adjusted_svc_date%type
406: ,employment_end_date per_periods_of_service.final_process_date%type
407: ,actual_termination_date per_periods_of_service.actual_termination_date%type

Line 404: ,app_object_version_number per_applications.object_version_number%type

400: ,termination_reason per_applications.termination_reason%type
401: ,termination_reason_meaning hr_lookups.meaning%type
402: ,app_date_received per_applications.date_received%type
403: ,app_date_end per_applications.date_end%type
404: ,app_object_version_number per_applications.object_version_number%type
405: ,adjusted_svc_date per_periods_of_service.adjusted_svc_date%type
406: ,employment_end_date per_periods_of_service.final_process_date%type
407: ,actual_termination_date per_periods_of_service.actual_termination_date%type
408: ,hire_date per_periods_of_service.date_start%type