APPS.OKS_AUTH_UTIL_PVT dependencies on OKX_CUST_SITES_V

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

6657: p_object_code IN VARCHAR2,
6658: p_id1 IN VARCHAR2,
6659: p_id2 IN VARCHAR2,
6660: x_name OUT NOCOPY VARCHAR2,
6661: x_addr OUT NOCOPY okx_cust_sites_v.description%TYPE)
6662: IS
6663: --l_name VARCHAR2(255);
6664: l_from_table VARCHAR2(200);
6665: l_where_clause VARCHAR2(2000);

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

6665: l_where_clause VARCHAR2(2000);
6666: l_sql_stmt VARCHAR2(1000);
6667: l_not_found BOOLEAN;
6668: l_cust_acct_site_id NUMBER;
6669: -- l_addr okx_cust_sites_v.description%type;
6670:
6671: CURSOR jtfv_csr IS
6672: SELECT FROM_TABLE, WHERE_CLAUSE
6673: FROM JTF_OBJECTS_B

Line 6680: FROM okx_cust_sites_v

6676: sql_csr SOURCE_CSR;
6677:
6678: CURSOR get_address_csr (p_cust_acct_site_id IN NUMBER) IS
6679: SELECT description
6680: FROM okx_cust_sites_v
6681: WHERE id1 = p_cust_acct_site_id;
6682: BEGIN
6683: OPEN jtfv_csr;
6684: FETCH jtfv_csr INTO l_from_table, l_where_clause;