APPS.PAY_US_GET_CUMU_PERIOD_NUM dependencies on PER_ALL_ASSIGNMENTS_F

Line 73: per_all_assignments_f ASS

69: -- get the minimum hire date
70: begin
71: select min(SERVICE.date_start) into l_hire_date
72: from per_periods_of_service SERVICE,
73: per_all_assignments_f ASS
74: where ASS.assignment_id = p_assignment_id
75: and ASS.person_id = SERVICE.person_id
76: and SERVICE.date_start <= l_date_paid;
77: exception when others then