APPS.PA_SCHEDULE_PUB dependencies on PA_SCHEDULE_EXCEPTIONS

Line 1211: -- Insert row to PA_SCHEDULE_EXCEPTIONS

1207: end if;
1208: END IF;
1209:
1210: --
1211: -- Insert row to PA_SCHEDULE_EXCEPTIONS
1212: --
1213: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_duration API ..... ');
1214: PA_SCH_EXCEPT_PKG.Insert_Rows(
1215: p_calendar_id => p_calendar_id

Line 2417: FROM pa_schedule_exceptions a , pa_project_assignments b

2413:
2414: -- This cursor will select the distinct assignment id
2415: CURSOR csr_sch_excp IS
2416: SELECT distinct a.assignment_id, b.record_version_number, b.project_id
2417: FROM pa_schedule_exceptions a , pa_project_assignments b
2418: WHERE a.assignment_id = b.assignment_id
2419: ORDER by a.assignment_id;
2420: BEGIN
2421: -- store the status success to track the error

Line 2549: FROM pa_schedule_exceptions

2545: Thursday_hours,
2546: Friday_hours,
2547: saturday_hours,
2548: Sunday_hours
2549: FROM pa_schedule_exceptions
2550: WHERE assignment_id = p_assignment_id
2551: AND ((p_exception_id IS NULL) OR
2552: (schedule_exception_id = p_exception_id))
2553: ORDER BY schedule_exception_id;