DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 422: FROM okc_k_party_roles_v

418:
419: --Check for the existing party roles
420: CURSOR check_line_party_csr IS
421: SELECT COUNT(1)
422: FROM okc_k_party_roles_v
423: WHERE dnz_chr_id = p_chr_id
424: AND chr_id = p_chr_id
425: AND rle_code = 'OKL_VENDOR'
426: AND JTOT_OBJECT1_CODE = 'OKX_VENDOR'

Line 432: FROM okc_k_party_roles_v

428: AND object1_id1 = p_vendor_id;
429:
430: CURSOR check_top_party_csr IS
431: SELECT COUNT(1)
432: FROM okc_k_party_roles_v
433: WHERE dnz_chr_id = p_chr_id
434: AND chr_id = p_chr_id
435: AND rle_code = 'OKL_VENDOR'
436: AND JTOT_OBJECT1_CODE = 'OKX_VENDOR'

Line 4511: FROM okc_k_party_roles_v

4507: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4508: --Check for the existing party roles
4509: CURSOR check_party_csr(p_chr_id NUMBER,p_customer_id NUMBER) IS
4510: SELECT COUNT(1)
4511: FROM okc_k_party_roles_v
4512: WHERE dnz_chr_id = p_chr_id
4513: AND chr_id = p_chr_id
4514: AND rle_code = G_RLE_CODE
4515: AND object1_id1 = p_customer_id;