DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 43: OKC_K_PARTY_ROLES_B CPLB

39:
40: CURSOR c_vendor_exist (p_khr_id NUMBER , p_isu_id NUMBER) IS
41: select 'x'
42: from
43: OKC_K_PARTY_ROLES_B CPLB
44: where CPLB.CHR_ID = p_khr_id
45: and CPLB.DNZ_CHR_ID = p_khr_id
46: and CPLB.OBJECT1_ID1 = p_isu_id
47: and CPLB.JTOT_OBJECT1_CODE = 'OKX_PARTY'

Line 381: from OKC_K_PARTY_ROLES_B CPLB

377:
378: CURSOR c_vendor_exist (p_khr_id NUMBER , p_isu_id NUMBER)
379: IS
380: select 'x'
381: from OKC_K_PARTY_ROLES_B CPLB
382: where CPLB.CHR_ID = p_khr_id
383: and CPLB.DNZ_CHR_ID = p_khr_id
384: and CPLB.OBJECT1_ID1 = p_isu_id
385: and CPLB.JTOT_OBJECT1_CODE = 'OKX_PARTY'

Line 6736: OKC_K_PARTY_ROLES_B CPLB

6732:
6733: CURSOR c_vendor_exist (p_khr_id NUMBER , p_isu_id NUMBER) IS
6734: select 'x'
6735: from
6736: OKC_K_PARTY_ROLES_B CPLB
6737: where CPLB.CHR_ID = p_khr_id
6738: and CPLB.DNZ_CHR_ID = p_khr_id
6739: and CPLB.OBJECT1_ID1 = p_isu_id
6740: and CPLB.JTOT_OBJECT1_CODE = 'OKX_VENDOR'