DBA Data[Home] [Help]

APPS.HRI_BPL_DATA_SETUP_DGNSTC dependencies on PER_PEOPLE_X

Line 107: ,per_people_x sup

103: ,assg.supervisor_id supervisor_id
104: FROM
105: per_all_assignments_f assg
106: ,per_assignment_status_types ast
107: ,per_people_x sup
108: ,per_people_x sub
109: WHERE assg.person_id = p_psn_id
110: AND p_date BETWEEN assg.effective_start_date
111: AND assg.effective_end_date

Line 108: ,per_people_x sub

104: FROM
105: per_all_assignments_f assg
106: ,per_assignment_status_types ast
107: ,per_people_x sup
108: ,per_people_x sub
109: WHERE assg.person_id = p_psn_id
110: AND p_date BETWEEN assg.effective_start_date
111: AND assg.effective_end_date
112: AND assg.assignment_status_type_id = ast.assignment_status_type_id