APPS.HR_RU_ASG_HOOK dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: FROM per_all_assignments_f

22: ,p_segment15 IN VARCHAR2
23: ) AS
24: CURSOR c_min_start_date(p_assignment_id NUMBER) IS
25: SELECT min(effective_start_date)
26: FROM per_all_assignments_f
27: WHERE assignment_id = p_assignment_id;
28:
29: CURSOR c_asg_details(p_assignment_id NUMBER,p_effective_date DATE) IS
30: SELECT person_id,effective_start_date,effective_end_date,business_group_id

Line 31: FROM per_all_assignments_f

27: WHERE assignment_id = p_assignment_id;
28:
29: CURSOR c_asg_details(p_assignment_id NUMBER,p_effective_date DATE) IS
30: SELECT person_id,effective_start_date,effective_end_date,business_group_id
31: FROM per_all_assignments_f
32: WHERE assignment_id = p_assignment_id
33: AND p_effective_date between effective_start_date and effective_end_date;
34: l_org_id NUMBER;
35: l_asg_status VARCHAR2(1);