APPS.MRP_AP_REL_PLAN_PUB dependencies on MRP_AP_APPS_INSTANCES_ALL

Line 1829: from MRP_AP_APPS_INSTANCES_ALL

1825: '@'||A2M_DBLINK),
1826: INSTANCE_ID
1827: into lv_dblink,
1828: lv_instance_id
1829: from MRP_AP_APPS_INSTANCES_ALL
1830: where instance_id = v_instance_id
1831: and instance_code = v_instance_code
1832: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
1833: and ALLOW_RELEASE_FLAG=1;

Line 2137: from MRP_AP_APPS_INSTANCES_ALL

2133: '@'||A2M_DBLINK),
2134: INSTANCE_ID
2135: into lv_dblink,
2136: lv_instance_id
2137: from MRP_AP_APPS_INSTANCES_ALL
2138: where instance_id = v_instance_id
2139: and instance_code = v_instance_code
2140: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2141: and ALLOW_RELEASE_FLAG=1;

Line 2524: from MRP_AP_APPS_INSTANCES_ALL

2520: '@'||A2M_DBLINK),
2521: INSTANCE_ID
2522: into lv_dblink,
2523: lv_instance_id
2524: from MRP_AP_APPS_INSTANCES_ALL
2525: where instance_id = v_instance_id
2526: and instance_code = v_instance_code
2527: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2528: and ALLOW_RELEASE_FLAG=1;

Line 2819: from MRP_AP_APPS_INSTANCES_ALL

2815: '@'||A2M_DBLINK),
2816: INSTANCE_ID
2817: into lv_dblink,
2818: lv_instance_id
2819: from MRP_AP_APPS_INSTANCES_ALL
2820: where instance_id = v_instance_id
2821: and instance_code = v_instance_code
2822: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2823: and ALLOW_RELEASE_FLAG=1;

Line 4244: from MRP_AP_APPS_INSTANCES_ALL

4240: '@'||A2M_DBLINK),
4241: INSTANCE_ID
4242: into lv_dblink,
4243: lv_instance_id
4244: from MRP_AP_APPS_INSTANCES_ALL
4245: where instance_id = v_instance_id
4246: and instance_code = v_instance_code
4247: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
4248: and ALLOW_RELEASE_FLAG=1;