DBA Data[Home] [Help]

APPS.MSC_EXCHANGE_BUCKETING dependencies on MSC_CAL_WEEK_START_DATES

Line 855: from msc_cal_week_start_dates

851:
852: cursor c1 is
853: select distinct to_number(to_char(WEEK_START_DATE,'j')) week_start_date,
854: to_number(to_char(NEXT_DATE-1,'j')) week_end_date
855: from msc_cal_week_start_dates
856: where CALENDAR_CODE = p_calendar_code
857: and SR_INSTANCE_ID = p_sr_instance_id
858: and EXCEPTION_SET_ID = -1
859: and ( (WEEK_START_DATE <= to_date(p_start_date,'j')

Line 1521: from MSC_CAL_WEEK_START_DATES

1517: select to_number(to_char(WEEK_START_DATE,'J') ) ,
1518: to_number(to_char(NEXT_DATE-1,'J') )
1519: into lv_w_start_date,
1520: lv_w_end_date
1521: from MSC_CAL_WEEK_START_DATES
1522: where SR_INSTANCE_ID = p_instance_id
1523: and CALENDAR_CODE = p_calendar_code
1524: and EXCEPTION_SET_ID = -1
1525: and l_curr_date between to_number(to_char(WEEK_START_DATE,'J'))