APPS.MSC_POST_PRO dependencies on FND_ORACLE_USERID

Line 179: FROM FND_ORACLE_USERID a,

175: msc_util.msc_log('Begin Post Processing');
176: l_retval := FND_INSTALLATION.GET_APP_INFO('FND', dummy1, dummy2, l_applsys_schema);
177: SELECT a.oracle_username
178: INTO l_msc_schema
179: FROM FND_ORACLE_USERID a,
180: FND_PRODUCT_INSTALLATIONS b
181: WHERE a.oracle_id = b.oracle_id
182: AND b.application_id = 724;
183:

Line 1155: FROM FND_ORACLE_USERID a,

1151:
1152: l_retval := FND_INSTALLATION.GET_APP_INFO('FND', dummy1, dummy2, l_applsys_schema);
1153: SELECT a.oracle_username
1154: INTO l_msc_schema
1155: FROM FND_ORACLE_USERID a,
1156: FND_PRODUCT_INSTALLATIONS b
1157: WHERE a.oracle_id = b.oracle_id
1158: AND b.application_id = 724;
1159:

Line 3695: FROM FND_ORACLE_USERID a,

3691:
3692: l_retval := FND_INSTALLATION.GET_APP_INFO('FND', dummy1, dummy2, l_applsys_schema);
3693: SELECT a.oracle_username
3694: INTO l_msc_schema
3695: FROM FND_ORACLE_USERID a,
3696: FND_PRODUCT_INSTALLATIONS b
3697: WHERE a.oracle_id = b.oracle_id
3698: AND b.application_id = 724;
3699:

Line 4203: FROM fnd_oracle_userid a,

4199: FND_GLOBAL.USER_ID
4200: INTO l_msc_schema,
4201: l_sysdate,
4202: l_user_id
4203: FROM fnd_oracle_userid a,
4204: fnd_product_installations b
4205: WHERE a.oracle_id = b.oracle_id
4206: AND b.application_id = 724;
4207:

Line 6489: FROM FND_ORACLE_USERID a,

6485: msc_util.msc_log('completely purging temp tables');
6486: --bug3545959 start
6487: SELECT a.oracle_username
6488: INTO l_mrp_schema
6489: FROM FND_ORACLE_USERID a,
6490: FND_PRODUCT_INSTALLATIONS b
6491: WHERE a.oracle_id = b.oracle_id
6492: AND b.application_id = 704;
6493:

Line 6502: FROM FND_ORACLE_USERID a,

6498:
6499: --bug3940999
6500: SELECT a.oracle_username
6501: INTO l_msc_schema
6502: FROM FND_ORACLE_USERID a,
6503: FND_PRODUCT_INSTALLATIONS b
6504: WHERE a.oracle_id = b.oracle_id
6505: AND b.application_id = 724;
6506: