APPS.JTY_TERR_DENORM_RULES_PVT dependencies on FND_ORACLE_USERID

Line 201: FROM fnd_product_installations i, fnd_application a, fnd_oracle_userid u

197:
198: /* get tablespace information */
199: SELECT i.tablespace, i.index_tablespace, u.oracle_username
200: INTO l_table_tablespace, l_idx_tablespace, l_ora_username
201: FROM fnd_product_installations i, fnd_application a, fnd_oracle_userid u
202: WHERE a.application_short_name = 'JTF'
203: AND a.application_id = i.application_id
204: AND u.oracle_id = i.oracle_id;
205:

Line 2407: FROM FND_ORACLE_USERID

2403: l_jtf_app_id NUMBER := 690;
2404:
2405: CURSOR c_prod(b_APP_ID NUMBER) IS
2406: SELECT ORACLE_USERNAME
2407: FROM FND_ORACLE_USERID
2408: WHERE ORACLE_ID=b_APP_ID;
2409: BEGIN
2410: -- debug message
2411: jty_log(FND_LOG.LEVEL_PROCEDURE,