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 9424: JTOT_OBJECT1_CODE,object1_id1,rle_code from OKC_K_PARTY_ROLES_V

9420:
9421:
9422: Cursor cur_party (P_id NUMBER) IS
9423: Select id,dnz_chr_id,chr_id,cpl_id,primary_yn,small_business_flag,women_owned_flag,cle_id,
9424: JTOT_OBJECT1_CODE,object1_id1,rle_code from OKC_K_PARTY_ROLES_V
9425: Where cle_id = p_id
9426: And dnz_chr_id = p_dnz_chr_id;
9427:
9428:

Line 10424: FROM OKC_K_Party_Roles_V pr,

10420: -------------------------------------------------
10421: CURSOR Cur_PTRLDet(P_Cle_Id IN NUMBER,
10422: P_role_Code IN varchar2) IS
10423: SELECT pr.ID
10424: FROM OKC_K_Party_Roles_V pr,
10425: OKC_K_LINES_B lv
10426: WHERE pr.cle_ID=p_cle_Id
10427: AND pr.Rle_Code=P_Role_Code
10428: AND pr.cle_id = lv.id