DBA Data[Home] [Help]

APPS.MSC_DRP_HORI_PLAN dependencies on MSC_CALENDAR_DATES

Line 167: FROM msc_calendar_dates cal,

163: -- This cursor selects the dates for the buckets.
164: -- -------------------------------------------------
165: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
166: SELECT cal.calendar_date
167: FROM msc_calendar_dates cal,
168: msc_trading_partners tp
169: WHERE tp.sr_tp_id = arg_plan_organization_id
170: AND tp.sr_instance_id = arg_plan_instance_id
171: AND tp.calendar_exception_set_id = cal.exception_set_id