DBA Data[Home] [Help]

APPS.MSC_RES_PLAN_PKG dependencies on MSC_CALENDAR_DATES

Line 710: ' from msc_net_resource_avail mra, msc_calendar_dates md'||

706: ru.start_date||','||ru.end_date);
707:
708: /*
709: msc_phub_util.log(
710: ' from msc_net_resource_avail mra, msc_calendar_dates md'||
711: ' where mra.plan_id(+) = '||ru.plan_id||
712: ' and mra.sr_instance_id(+) = '||ru.sr_instance_id||
713: ' and mra.organization_id(+) = '||ru.organization_id||
714: ' and mra.department_id(+) = '||ru.department_id||

Line 768: from msc_net_resource_avail mra, msc_calendar_dates md

764: mra.parent_id,
765: mra.capacity_units,
766: fnd_global.user_id, sysdate,
767: sysdate, fnd_global.user_id, fnd_global.login_id
768: from msc_net_resource_avail mra, msc_calendar_dates md
769: where mra.plan_id(+) = ru.plan_id
770: and mra.sr_instance_id(+) = ru.sr_instance_id
771: and mra.organization_id(+) = ru.organization_id
772: and mra.department_id(+) = ru.department_id