APPS.POREQ dependencies on PER_ASSIGNMENTS_F

Line 115: FROM per_assignments_f pera

111: --
112: cursor GetApproverSup( b_employee_id number ) is
113: --
114: SELECT pera.supervisor_id forward_to_id
115: FROM per_assignments_f pera
116: WHERE pera.business_group_id = fsp.business_group_id
117: AND TRUNC(sysdate) BETWEEN pera.effective_start_date
118: AND pera.effective_end_date
119: CONNECT

Line 227: FROM per_assignments_f paf

223: if ( fsp.use_positions_flag = 'Y' ) then
224: --
225: SELECT nvl(PAF.position_id,0)
226: INTO l_position_id
227: FROM per_assignments_f paf
228: WHERE paf.person_id = p_employee_id
229: AND paf.assignment_type = 'E'
230: AND paf.primary_flag = 'Y'
231: AND sysdate BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 260: FROM per_assignments_f PAF

256: else -- Not using positions
257: --
258: SELECT nvl(paf.job_id, 0)
259: INTO l_job_id
260: FROM per_assignments_f PAF
261: WHERE paf.person_id = p_employee_id
262: AND paf.assignment_type = 'E'
263: AND paf.primary_flag = 'Y'
264: AND sysdate BETWEEN paf.effective_start_date AND paf.effective_end_date;