APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on FND_PRODUCT_INSTALLATIONS

Line 114: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

110: x_msg_data OUT NOCOPY VARCHAR2) IS
111:
112: CURSOR C_SCHEMA IS
113: SELECT a.oracle_username
114: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
115: WHERE a.oracle_id = b.oracle_id
116: AND b.application_id = 724;
117:
118: l_partition_name VARCHAR2(100);

Line 199: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

195: IS
196:
197: CURSOR C_SCHEMA IS
198: SELECT a.oracle_username
199: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
200: WHERE a.oracle_id = b.oracle_id
201: AND b.application_id = 724;
202:
203:

Line 347: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

343: IS
344:
345: CURSOR C_SCHEMA IS
346: SELECT a.oracle_username
347: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
348: WHERE a.oracle_id = b.oracle_id
349: AND b.application_id = 724;
350:
351: l_dummy_partition_name VARCHAR2(100);

Line 1360: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

1356:
1357:
1358: Cursor msc_schema IS
1359: SELECT a.oracle_username
1360: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
1361: WHERE a.oracle_id = b.oracle_id
1362: AND b.application_id= 724;
1363:
1364: /* --bug 3274373: Refresh Materialized view in ATP post plan processing.