DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_CALENDAR_MONTHS

Line 54185: select mcm.year_start_date from msc_calendar_months mcm

54181: --changes for bug 8613033
54182: update msc_st_bis_periods msbp
54183: set msbp.year_start_date=
54184: (
54185: select mcm.year_start_date from msc_calendar_months mcm
54186: where mcm.sr_instance_id = v_instance_id
54187: and mcm.calendar_type = 'FISCAL'
54188: and msbp.sr_instance_id = mcm.sr_instance_id
54189: and to_char(msbp.start_date,'MON-RR') = to_char(mcm.month_start_date,'MON-RR')

Line 54193: select mcm.quarter_start_date from msc_calendar_months mcm

54189: and to_char(msbp.start_date,'MON-RR') = to_char(mcm.month_start_date,'MON-RR')
54190: ),
54191: msbp.quarter_start_date =
54192: (
54193: select mcm.quarter_start_date from msc_calendar_months mcm
54194: where mcm.sr_instance_id = v_instance_id
54195: and mcm.calendar_type = 'FISCAL'
54196: and msbp.sr_instance_id = mcm.sr_instance_id
54197: and to_char(msbp.start_date,'MON-RR') = to_char(mcm.month_start_date,'MON-RR')