APPS.MSC_PHUB_PKG dependencies on MSC_APPS_INSTANCES

Line 1856: from msc_apps_instances

1852:
1853: --get last collection id
1854: select lcid
1855: into l_lcid
1856: from msc_apps_instances
1857: where instance_id=p_sr_instance_id;
1858:
1859: --populate msc_plan_buckets one row for days between sysdate and l_horizon_date
1860: msc_phub_util.log('Populating msc_plan_buckets');

Line 1990: from msc_apps_instances where instance_id=p_sr_instance_id;

1986: when no_data_found then
1987: msc_phub_util.log('msc_phub_pkg.populate_ods_details.exception: l_plan_run_id is null');
1988:
1989: select instance_code into l_instance_code
1990: from msc_apps_instances where instance_id=p_sr_instance_id;
1991:
1992: l_plan_run_id := create_plan_run(l_instance_code, sys_no, sys_yes, l_pi);
1993: end;
1994: