APPS.PA_RATE_PVT_PKG dependencies on PA_SCHEDULES

Line 1600: FROM pa_schedules

1596: IF (p_completion_date IS NULL) THEN /* Bug fix 1842755 */
1597: BEGIN
1598: SELECT MAX(end_date)
1599: INTO l_completion_date
1600: FROM pa_schedules
1601: WHERE project_id = p_project_id
1602: AND DECODE (schedule_type_code, 'OPEN_ASSIGNMENT',
1603: pa_assignment_utils.Is_Asgmt_In_Open_Status(status_code,'OPEN_ASGMT'),
1604: 'STAFFED_ASSIGNMENT',DECODE(