DBA Data[Home] [Help]

APPS.CN_TBLSPC_PKG dependencies on FND_PRODUCT_INSTALLATIONS

Line 11: FROM fnd_product_installations

7: FUNCTION get_tablespace RETURN varchar2 IS
8: l_tablespace varchar2(30);
9: CURSOR l_tblspc_csr IS
10: SELECT tablespace
11: FROM fnd_product_installations
12: WHERE application_id = 283;
13: BEGIN
14: OPEN l_tblspc_csr;
15: FETCH l_tblspc_csr INTO l_tablespace;

Line 28: FROM fnd_product_installations

24: FUNCTION get_index_tablespace RETURN varchar2 IS
25: l_ind_tablespace varchar2(30);
26: CURSOR l_itblspc_csr IS
27: SELECT index_tablespace
28: FROM fnd_product_installations
29: WHERE application_id = 283;
30: BEGIN
31: OPEN l_itblspc_csr;
32: FETCH l_itblspc_csr INTO l_ind_tablespace;