APPS.OKS_COVERAGES_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 547: FROM OKC_K_Party_Roles_V pr,

543: pr.FACILITY,
544: pr.MINORITY_GROUP_LOOKUP_CODE,
545: pr.SMALL_BUSINESS_FLAG,
546: pr.WOMEN_OWNED_FLAG
547: FROM OKC_K_Party_Roles_V pr,
548: OKC_K_LINES_B lv
549: WHERE pr.cle_ID=p_cle_Id
550: AND pr.Rle_Code=P_Role_Code
551: AND pr.cle_id = lv.id

Line 9414: JTOT_OBJECT1_CODE,object1_id1,rle_code from OKC_K_PARTY_ROLES_V

9410:
9411:
9412: Cursor cur_party (P_id NUMBER) IS
9413: Select id,dnz_chr_id,chr_id,cpl_id,primary_yn,small_business_flag,women_owned_flag,cle_id,
9414: JTOT_OBJECT1_CODE,object1_id1,rle_code from OKC_K_PARTY_ROLES_V
9415: Where cle_id = p_id
9416: And dnz_chr_id = p_dnz_chr_id;
9417:
9418:

Line 10414: FROM OKC_K_Party_Roles_V pr,

10410: -------------------------------------------------
10411: CURSOR Cur_PTRLDet(P_Cle_Id IN NUMBER,
10412: P_role_Code IN varchar2) IS
10413: SELECT pr.ID
10414: FROM OKC_K_Party_Roles_V pr,
10415: OKC_K_LINES_B lv
10416: WHERE pr.cle_ID=p_cle_Id
10417: AND pr.Rle_Code=P_Role_Code
10418: AND pr.cle_id = lv.id