DBA Data[Home] [Help]

APPS.PQH_PSP_INTEGRATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 143: From per_all_assignments_f

139: Cursor csr_asg_entities(p_assignment_id NUMBER,p_start_date DATE, p_end_date DATE) IS
140: Select position_id ,organization_id,
141: grade_id,job_id,
142: effective_start_date,effective_end_date
143: From per_all_assignments_f
144: Where assignment_id=p_assignment_id And
145: position_id is not null And
146: effective_start_date >= p_start_date And
147: effective_end_date <= p_end_date;