APPS.OKS_EXTWARPRGM_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 2213: FROM okx_customer_accounts_v ca, okx_cust_site_uses_v cs

2209: --Third party id
2210: CURSOR l_thirdparty_csr (p_id NUMBER)
2211: IS
2212: SELECT ca.party_id
2213: FROM okx_customer_accounts_v ca, okx_cust_site_uses_v cs
2214: WHERE ca.id1 = cs.cust_account_id AND cs.id1 = p_id;
2215:
2216: --party id
2217: CURSOR l_cust_csr (p_contactid NUMBER)

Line 9478: FROM okx_customer_accounts_v

9474: IS
9475: CURSOR l_party_csr
9476: IS
9477: SELECT party_id, NAME
9478: FROM okx_customer_accounts_v
9479: WHERE id1 = p_cust_id;
9480: BEGIN
9481: OPEN l_party_csr;
9482:

Line 9553: FROM okx_customer_accounts_v

9549:
9550: CURSOR l_party_csr (p_id NUMBER)
9551: IS
9552: SELECT party_id, NAME
9553: FROM okx_customer_accounts_v
9554: WHERE id1 = p_id;
9555:
9556: CURSOR l_get_agrid_csr (p_chr_id NUMBER)
9557: IS

Line 10034: FROM okx_customer_accounts_v

10030:
10031: CURSOR l_party_csr (p_id NUMBER)
10032: IS
10033: SELECT party_id, NAME
10034: FROM okx_customer_accounts_v
10035: WHERE id1 = p_id;
10036:
10037: CURSOR l_hdr_sts_csr (p_hdr_id NUMBER)
10038: IS