APPS.OKS_EXTWARPRGM_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 2253: FROM okx_customer_accounts_v ca, okx_cust_site_uses_v cs

2249: --Third party id
2250: CURSOR l_thirdparty_csr (p_id NUMBER)
2251: IS
2252: SELECT ca.party_id
2253: FROM okx_customer_accounts_v ca, okx_cust_site_uses_v cs
2254: WHERE ca.id1 = cs.cust_account_id AND cs.id1 = p_id;
2255:
2256: --party id
2257: CURSOR l_cust_csr (p_contactid NUMBER)

Line 9722: FROM okx_customer_accounts_v

9718: IS
9719: CURSOR l_party_csr
9720: IS
9721: SELECT party_id, NAME
9722: FROM okx_customer_accounts_v
9723: WHERE id1 = p_cust_id;
9724: BEGIN
9725: OPEN l_party_csr;
9726:

Line 9797: FROM okx_customer_accounts_v

9793:
9794: CURSOR l_party_csr (p_id NUMBER)
9795: IS
9796: SELECT party_id, NAME
9797: FROM okx_customer_accounts_v
9798: WHERE id1 = p_id;
9799:
9800: CURSOR l_get_agrid_csr (p_chr_id NUMBER)
9801: IS

Line 10282: FROM okx_customer_accounts_v

10278:
10279: CURSOR l_party_csr (p_id NUMBER)
10280: IS
10281: SELECT party_id, NAME
10282: FROM okx_customer_accounts_v
10283: WHERE id1 = p_id;
10284:
10285: CURSOR l_hdr_sts_csr (p_hdr_id NUMBER)
10286: IS