APPS.PAY_GB_ENROLL_PENSION dependencies on PER_ALL_ASSIGNMENTS_F

Line 257: select assignment_number from per_all_assignments_f

253: G_DEFAULT_ELEMENT_DUMMY PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
254:
255: CURSOR get_assignment_number (p_assignment_id number)
256: is
257: select assignment_number from per_all_assignments_f
258: where assignment_id=p_assignment_id
259: AND G_PRP_END_DATE >= EFFECTIVE_START_DATE
260: AND G_PRP_START_DATE <= EFFECTIVE_END_DATE;
261: --and G_PRP_END_DATE between effective_start_date and effective_end_date;