APPS.PA_SCHEDULE_PUB dependencies on PA_SCHEDULE_EXCEPTIONS

Line 1682: -- Insert row to PA_SCHEDULE_EXCEPTIONS

1678: end if;
1679: END IF;
1680:
1681: --
1682: -- Insert row to PA_SCHEDULE_EXCEPTIONS
1683: --
1684: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_duration API ..... ');
1685: PA_SCH_EXCEPT_PKG.Insert_Rows(
1686: p_calendar_id => p_calendar_id

Line 2889: FROM pa_schedule_exceptions a , pa_project_assignments b

2885:
2886: -- This cursor will select the distinct assignment id
2887: CURSOR csr_sch_excp IS
2888: SELECT distinct a.assignment_id, b.record_version_number, b.project_id
2889: FROM pa_schedule_exceptions a , pa_project_assignments b
2890: WHERE a.assignment_id = b.assignment_id
2891: ORDER by a.assignment_id;
2892: BEGIN
2893: -- store the status success to track the error

Line 3022: FROM pa_schedule_exceptions

3018: Thursday_hours,
3019: Friday_hours,
3020: saturday_hours,
3021: Sunday_hours
3022: FROM pa_schedule_exceptions
3023: WHERE assignment_id = p_assignment_id
3024: AND ((p_exception_id IS NULL) OR
3025: (schedule_exception_id = p_exception_id))
3026: ORDER BY schedule_exception_id;