APPS.MSC_POST_PRO dependencies on FND_PRODUCT_INSTALLATIONS

Line 180: FND_PRODUCT_INSTALLATIONS b

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:
184: msc_util.msc_log('l_applsys_schema ;= ' || l_applsys_schema);

Line 1156: FND_PRODUCT_INSTALLATIONS b

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:
1160: FOR i in 1..atp_summ_tab.count LOOP

Line 3696: FND_PRODUCT_INSTALLATIONS b

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:
3700:

Line 4204: fnd_product_installations b

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:
4208: FOR i in 1..atp_summ_tab.count LOOP

Line 6490: FND_PRODUCT_INSTALLATIONS b

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:
6494: msc_util.msc_log('l_mrp_schema: ' || l_mrp_schema );

Line 6503: FND_PRODUCT_INSTALLATIONS b

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:
6507: msc_util.msc_log('l_msc_schema: ' || l_msc_schema );