APPS.OE_OE_PRICING_AVAILABILITY dependencies on MRP_AP_APPS_INSTANCES

Line 6348: FROM mrp_ap_apps_instances;

6344: l_instance_id number;
6345: CURSOR c_instance_id IS
6346: SELECT instance_id,
6347: instance_code
6348: FROM mrp_ap_apps_instances;
6349:
6350: l_mrp_atp_database_link varchar2(300);
6351: x_assignment_set_id number;
6352: x_assignment_set_name varchar2(300);

Line 6417: -- table mrp_ap_apps_instances 4113599

6413:
6414:
6415: x_return_status := 'S';
6416: -- No need to check profile.. Instead get the link from
6417: -- table mrp_ap_apps_instances 4113599
6418: -- l_mrp_atp_database_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
6419:
6420: --Bug 6716697: Wrong dblink name was selected. Corrcted as per ATP team
6421: select a2m_dblink

Line 6423: from mrp_ap_apps_instances;

6419:
6420: --Bug 6716697: Wrong dblink name was selected. Corrcted as per ATP team
6421: select a2m_dblink
6422: into l_mrp_atp_database_link
6423: from mrp_ap_apps_instances;
6424:
6425: IF l_debug_level > 0 THEN
6426: oe_debug_pub.add( 'L_INSTANCE_ID='||L_INSTANCE_ID|| ' DB LINK='
6427: ||L_MRP_ATP_DATABASE_LINK ||' Ins Code='||l_instance_code) ;