DBA Data[Home] [Help]

APPS.PER_QH_FIND_QUERY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 266: ,assignment_status_type per_assignment_status_types.user_status%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
270: ,person_referred_by per_all_people_f.full_name%type

Line 267: ,system_status per_assignment_status_types.per_system_status%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
270: ,person_referred_by per_all_people_f.full_name%type
271: ,supervisor per_all_people_f.full_name%type

Line 643: ,assignment_status_type per_assignment_status_types.user_status%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
646: ,payroll_id per_all_assignments_f.payroll_id%type default null
647: ,location hr_locations.location_code%type default null

Line 747: ,assignment_status_type in per_assignment_status_types.user_status%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
750: ,payroll_id in per_all_assignments_f.payroll_id%type default null
751: ,location in hr_locations.location_code%type default null