APPS.PER_QH_FIND_QUERY dependencies on PER_JOBS

Line 265: ,job per_jobs.name%type

261: ,recruiter per_all_people_f.full_name%type
262: ,grade per_grades.name%type
263: ,grade_ladder ben_pgm_f.name%type
264: ,position hr_all_positions_f.name%type
265: ,job per_jobs.name%type
266: ,assignment_status_type per_assignment_status_types.user_status%type
267: ,system_status per_assignment_status_types.per_system_status%type
268: ,payroll pay_all_payrolls_f.payroll_name%type
269: ,location hr_locations.location_code%type

Line 641: ,job per_jobs.name%type default null

637: ,grade_ladder ben_pgm_f.name%type default null
638: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
639: ,position hr_all_positions_f.name%type default null
640: ,position_id per_all_assignments_f.position_id%type default null
641: ,job per_jobs.name%type default null
642: ,job_id per_all_assignments_f.job_id%type default null
643: ,assignment_status_type per_assignment_status_types.user_status%type default null
644: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
645: ,payroll pay_all_payrolls_f.payroll_name%type default null

Line 745: ,job in per_jobs.name%type default null

741: ,grade_ladder in ben_pgm_f.name%type default null
742: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
743: ,position in hr_all_positions_f.name%type default null
744: ,position_id in per_all_assignments_f.position_id%type default null
745: ,job in per_jobs.name%type default null
746: ,job_id in per_all_assignments_f.job_id%type default null
747: ,assignment_status_type in per_assignment_status_types.user_status%type default null
748: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
749: ,payroll in pay_all_payrolls_f.payroll_name%type default null