APPS.OKE_CONTRACT_PARTY_PUB dependencies on OKC_K_PARTY_ROLES_V

Line 341: l_sql_stmt := ADD_WHERE_TO_SQL( l_sql_stmt, ' ID1 in (select object1_id1 from okc_k_party_roles_v'

337: end if;
338: END IF; --buy_or_Sell
339:
340: IF p_cplv_rec.cle_id IS NOT NULL AND p_cplv_rec.cle_id<>OKC_API.G_MISS_NUM then
341: l_sql_stmt := ADD_WHERE_TO_SQL( l_sql_stmt, ' ID1 in (select object1_id1 from okc_k_party_roles_v'
342: || ' where RLE_CODE= '||''''||p_cplv_rec.RLE_CODE||''''|| ' AND chr_id = '||p_cplv_rec.dnz_chr_id||')');
343:
344: END IF;
345:

Line 749: -- FUNCTION get_rec for: OKC_K_PARTY_ROLES_V

745: l_JTOT_OBJECT1_CODE VARCHAR2(40);
746: l_cplv_rec cplv_rec_type;
747:
748: ---------------------------------------------------------------------------
749: -- FUNCTION get_rec for: OKC_K_PARTY_ROLES_V
750: ---------------------------------------------------------------------------
751: FUNCTION get_rec (
752: p_cplv_rec IN cplv_rec_type,
753: x_no_data_found OUT NOCOPY BOOLEAN

Line 798: FROM Okc_K_Party_Roles_V

794: CREATION_DATE,
795: LAST_UPDATED_BY,
796: LAST_UPDATE_DATE,
797: LAST_UPDATE_LOGIN
798: FROM Okc_K_Party_Roles_V
799: WHERE okc_k_party_roles_v.id = p_id;
800: l_okc_cplv_pk okc_cplv_pk_csr%ROWTYPE;
801: l_cplv_rec cplv_rec_type;
802: BEGIN

Line 799: WHERE okc_k_party_roles_v.id = p_id;

795: LAST_UPDATED_BY,
796: LAST_UPDATE_DATE,
797: LAST_UPDATE_LOGIN
798: FROM Okc_K_Party_Roles_V
799: WHERE okc_k_party_roles_v.id = p_id;
800: l_okc_cplv_pk okc_cplv_pk_csr%ROWTYPE;
801: l_cplv_rec cplv_rec_type;
802: BEGIN
803: