APPS.PA_RATE_PVT_PKG dependencies on PA_SCHEDULES

Line 1669: FROM pa_schedules

1665: IF (p_completion_date IS NULL) THEN /* Bug fix 1842755 */
1666: BEGIN
1667: SELECT MAX(end_date)
1668: INTO l_completion_date
1669: FROM pa_schedules
1670: WHERE project_id = p_project_id
1671: AND DECODE (schedule_type_code, 'OPEN_ASSIGNMENT',
1672: pa_assignment_utils.Is_Asgmt_In_Open_Status(status_code,'OPEN_ASGMT'),
1673: 'STAFFED_ASSIGNMENT',DECODE(