APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 249: FROM OKC_K_PARTY_ROLES_B

245: p_party_id IN NUMBER) RETURN NUMBER
246: IS
247: CURSOR l_role_csr IS
248: SELECT ID
249: FROM OKC_K_PARTY_ROLES_B
250: WHERE DNZ_CHR_ID = p_dnz_chr_id
251: AND CLE_ID = P_Cle_Id
252: AND OBJECT1_ID1 = p_party_id ; -- Bug 5219132
253:

Line 289: FROM OKC_K_PARTY_ROLES_B

285: l_party_id NUMBER;
286:
287: CURSOR role_csr IS
288: SELECT rle_code,OBJECT1_ID1,object1_id2,JTOT_OBJECT1_CODE
289: FROM OKC_K_PARTY_ROLES_B
290: WHERE object1_id1= l_party_id
291: and dnz_chr_id = p_dnz_chr_id;
292:
293: Cursor get_contract_type IS

Line 659: (select object1_id1 from okc_k_party_roles_b

655: p_billto_id in NUMBER) is
656: Select cust_acct_id
657: from okx_cust_contacts_v
658: where party_id in
659: (select object1_id1 from okc_k_party_roles_b
660: where dnz_chr_id = p_chr_id--:PARAMETER.OKSDEFLT_CHR_ID
661: and chr_id = p_chr_id--:PARAMETER.OKSDEFLT_CHR_ID
662: and cle_id IS NULL
663: and rle_code <> 'VENDOR'

Line 681: FROM OKC_K_PARTY_ROLES_B

677: AND a.site_use_code = use;
678:
679: CURSOR Party_role_csr (p_dnz_chr_id IN NUMBER,p_cle_id IN NUMBER) IS
680: SELECT id, cle_id, dnz_chr_id
681: FROM OKC_K_PARTY_ROLES_B
682: WHERE DNZ_CHR_ID = p_dnz_chr_id
683: AND CLE_ID = P_Cle_Id;
684: -- AND OBJECT1_ID1 =l_party_id;
685:

Line 698: FROM OKC_K_PARTY_ROLES_B

694:
695:
696: CURSOR CUR_LINE_PARTY_ROLE ( P_CHR_ID IN NUMBER, P_CLE_ID IN NUMBER, l_party_id IN NUMBER) IS
697: SELECT id
698: FROM OKC_K_PARTY_ROLES_B
699: WHERE DNZ_CHR_ID = p_chr_id
700: AND CLE_ID = p_cle_id
701: AND OBJECT1_ID1 =l_party_id;
702: