DBA Data[Home] [Help]

APPS.HR_RU_ASG_HOOK dependencies on PER_ALL_PEOPLE_F

Line 219: FROM per_all_people_f

215: ,p_scl_segment15 IN VARCHAR2
216: ) AS
217: CURSOR c_person_details(p_person_id NUMBER,p_effective_date DATE) IS
218: SELECT business_group_id
219: FROM per_all_people_f
220: WHERE person_id = p_person_id
221: AND p_effective_date between effective_start_date and effective_end_date;
222: l_org_id NUMBER;
223: l_asg_status VARCHAR2(1);