DBA Data[Home] [Help]

APPS.PER_QH_FIND_QUERY dependencies on HR_LOCATIONS

Line 269: ,location hr_locations.location_code%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
272: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type
273: ,recruitment_activity per_recruitment_activities.name%type

Line 647: ,location hr_locations.location_code%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
648: ,location_id per_all_assignments_f.location_id%type default null
649: ,supervisor per_all_people_f.full_name%type default null
650: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
651: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null

Line 751: ,location in hr_locations.location_code%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
752: ,location_id in per_all_assignments_f.location_id%type default null
753: ,supervisor in per_all_people_f.full_name%type default null
754: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
755: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null