APPS.HRWSECI dependencies on PER_ASSIGNMENTS_F

Line 247: FROM per_assignments_f a

243: WHERE position_id = p_position_id;
244: --
245: CURSOR chk_hrs_reduced IS
246: SELECT 'Y'
247: FROM per_assignments_f a
248: WHERE a.assignment_id = p_assignment_id
249: AND a.business_group_id + 0 = p_business_group_id
250: AND p_qualifying_date
251: BETWEEN a.effective_start_date AND

Line 429: FROM per_assignments_F a

425: --
426: CURSOR org_id IS
427: SELECT organization_id,
428: position_id
429: FROM per_assignments_F a
430: WHERE a.assignment_id = p_assignment_id
431: AND a.business_group_id + 0 = p_business_group_id
432: AND p_qualifying_date
433: BETWEEN a.effective_start_date AND