1480: /* Refresh the existing Org Calendar relationships for this instance */
1481:
1482: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1483:
1484: delete from msd_st_org_calendars
1485: where instance = p_instance_id;
1486:
1487: v_dest_table := 'MSD_ST_ORG_CALENDARS';
1488:
1483:
1484: delete from msd_st_org_calendars
1485: where instance = p_instance_id;
1486:
1487: v_dest_table := 'MSD_ST_ORG_CALENDARS';
1488:
1489: else
1490:
1491: delete from msd_org_calendars
1522: instance,
1523: sr_org_pk,
1524: calendar_type,
1525: calendar_code
1526: from msd_st_org_calendars
1527: where instance = p_instance_id) a;
1528:
1529: delete from msd_st_org_calendars where instance = p_instance_id;
1530:
1525: calendar_code
1526: from msd_st_org_calendars
1527: where instance = p_instance_id) a;
1528:
1529: delete from msd_st_org_calendars where instance = p_instance_id;
1530:
1531:
1532: else
1533: