APPS.MSD_LIABILITY dependencies on MSD_TIME_LB

Line 747: FROM msd_time_lb_v dp

743: /* This cursor returns the start date and end date of a given calendar */
744: CURSOR get_tim(p_calendar_type VARCHAR2, p_calendar_code VARCHAR2,
745: p_start_date DATE, p_end_date DATE) IS
746: SELECT MIN(day) min_date, MAX(day) max_date
747: FROM msd_time_lb_v dp
748: WHERE dp.calendar_type = p_calendar_type
749: AND dp.calendar_code = p_calendar_code ;
750: --AND day between p_start_date and p_end_date;
751:

Line 2328: delete from msd_time_lb where CALENDAR_CODE in

2324: IS
2325:
2326: BEGIN
2327:
2328: delete from msd_time_lb where CALENDAR_CODE in
2329: ( select CALENDAR_CODE from msd_dp_calendars where demand_plan_id = p_demand_plan_id)
2330: ;
2331:
2332: commit ;

Line 2334: insert into msd_time_lb (

2330: ;
2331:
2332: commit ;
2333:
2334: insert into msd_time_lb (
2335: CALENDAR_TYPE,
2336: CALENDAR_CODE,
2337: SEQ_NUM,
2338: YEAR,