DBA Data[Home] [Help]

APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on MSC_PERIOD_START_DATES

Line 255: from msc_period_start_dates cal , msc_trading_partners mtp

251: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_start_date: '||TO_CHAR(v_weekly_start_date,'DD-MON-YYYY'));
252:
253: select min(cal.period_start_date)
254: into v_period_start_date
255: from msc_period_start_dates cal , msc_trading_partners mtp
256: where cal.exception_set_id = mtp.calendar_exception_set_id
257: and cal.calendar_code = mtp.calendar_code
258: and cal.period_start_date >= nvl(trunc(v_weekly_cutoff_date),trunc(v_daily_cutoff_date))
259: and cal.sr_instance_id = G_inst_id