APPS.PA_SCHEDULE_UTILS dependencies on PA_SCHEDULES

Line 970: FROM pa_schedules

966:
967: l_flag VARCHAR2(1) := 'Y';
968: CURSOR l_sch_csr IS
969: SELECT status_code
970: FROM pa_schedules
971: WHERE assignment_id = p_assignment_id;
972:
973: BEGIN
974: FOR l_sch_rec IN l_sch_csr LOOP

Line 1295: from pa_schedules

1291: trunc(max(end_date)) max_end_date,
1292: max(monday_hours) + max(tuesday_hours) + max(wednesday_hours) +
1293: max(thursday_hours) + max(friday_hours) + max(saturday_hours) +
1294: max(sunday_hours) max_total_hours
1295: from pa_schedules
1296: where schedule_type_code = 'CALENDAR'
1297: and calendar_id = p_calendar_id;
1298:
1299: BEGIN