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 6743: OKC_K_PARTY_ROLES_B CPLB

6739:
6740: CURSOR c_vendor_exist (p_khr_id NUMBER , p_isu_id NUMBER) IS
6741: select 'x'
6742: from
6743: OKC_K_PARTY_ROLES_B CPLB
6744: where CPLB.CHR_ID = p_khr_id
6745: and CPLB.DNZ_CHR_ID = p_khr_id
6746: and CPLB.OBJECT1_ID1 = p_isu_id
6747: and CPLB.JTOT_OBJECT1_CODE = 'OKX_VENDOR'