DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 420: FROM okc_k_party_roles_v

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

Line 430: FROM okc_k_party_roles_v

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

Line 4398: FROM okc_k_party_roles_v

4394: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4395: --Check for the existing party roles
4396: CURSOR check_party_csr(p_chr_id NUMBER,p_customer_id NUMBER) IS
4397: SELECT COUNT(1)
4398: FROM okc_k_party_roles_v
4399: WHERE dnz_chr_id = p_chr_id
4400: AND chr_id = p_chr_id
4401: AND rle_code = G_RLE_CODE
4402: AND object1_id1 = p_customer_id;