APPS.PER_COBRA_ECI dependencies on PER_ASSIGNMENTS_F

Line 286: FROM per_assignments_f a

282: and effective_end_date;
283: --
284: CURSOR chk_hrs_reduced IS
285: SELECT 'Y'
286: FROM per_assignments_f a
287: WHERE a.assignment_id = p_assignment_id
288: AND a.business_group_id + 0 = p_business_group_id
289: AND p_qualifying_date
290: BETWEEN a.effective_start_date AND

Line 472: FROM per_assignments_F a

468: --
469: CURSOR org_id IS
470: SELECT organization_id,
471: position_id
472: FROM per_assignments_F a
473: WHERE a.assignment_id = p_assignment_id
474: AND a.business_group_id + 0 = p_business_group_id
475: AND p_qualifying_date
476: BETWEEN a.effective_start_date AND