APPS.CN_SCA_UTL_PVT dependencies on FND_APPLICATION

Line 112: FROM fnd_application

108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: SELECT application_short_name
111: INTO l_cn_schema
112: FROM fnd_application
113: WHERE application_id = 283;
114:
115: l_schema_return := fnd_installation.get_app_info(
116: l_cn_schema,

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

153: --+
154:
155: SELECT i.tablespace, i.index_tablespace, u.oracle_username
156: INTO l_table_tablespace, l_idx_tablespace, l_ora_username
157: FROM fnd_product_installations i, fnd_application a, fnd_oracle_userid u
158: WHERE a.application_short_name = l_cn_schema
159: AND a.application_id = i.application_id
160: AND u.oracle_id = i.oracle_id;
161: