APPS.OKS_AUTH_UTIL_PVT dependencies on OKX_CUST_SITES_V

Line 6041: x_addr OUT NOCOPY okx_cust_sites_v.description%TYPE)

6037: p_object_code IN VARCHAR2,
6038: p_id1 IN VARCHAR2,
6039: p_id2 IN VARCHAR2,
6040: x_name OUT NOCOPY VARCHAR2,
6041: x_addr OUT NOCOPY okx_cust_sites_v.description%TYPE)
6042: IS
6043: --l_name VARCHAR2(255);
6044: l_from_table VARCHAR2(200);
6045: l_where_clause VARCHAR2(2000);

Line 6049: -- l_addr okx_cust_sites_v.description%type;

6045: l_where_clause VARCHAR2(2000);
6046: l_sql_stmt VARCHAR2(1000);
6047: l_not_found BOOLEAN;
6048: l_cust_acct_site_id NUMBER;
6049: -- l_addr okx_cust_sites_v.description%type;
6050:
6051: CURSOR jtfv_csr IS
6052: SELECT FROM_TABLE, WHERE_CLAUSE
6053: FROM JTF_OBJECTS_B

Line 6060: FROM okx_cust_sites_v

6056: sql_csr SOURCE_CSR;
6057:
6058: CURSOR get_address_csr (p_cust_acct_site_id IN NUMBER) IS
6059: SELECT description
6060: FROM okx_cust_sites_v
6061: WHERE id1 = p_cust_acct_site_id;
6062: BEGIN
6063: OPEN jtfv_csr;
6064: FETCH jtfv_csr INTO l_from_table, l_where_clause;