APPS.OKS_COVERAGES_PVT dependencies on OKC_CONTACTS_V

Line 564: FROM OKC_CONTACTS_V

560: OBJECT1_ID1,
561: OBJECT1_ID2,
562: JTOT_OBJECT1_CODE,
563: resource_class
564: FROM OKC_CONTACTS_V
565: WHERE cpl_id=P_cpl_Id;
566: --------------------------------------------
567:
568: CURSOR CUR_ItemDet(P_Id IN NUMBER) IS

Line 4558: OKC_CONTACTS_V ocv,

4554: ocv.object1_id1 res_id,
4555: ocv.resource_class resource_class
4556: FROM OKC_K_LINES_V lines,
4557: OKC_K_PARTY_ROLES_B party,
4558: OKC_CONTACTS_V ocv,
4559: OKC_K_ITEMS_V items
4560: WHERE lines.id = p_bp_line_id
4561: AND lines.lse_id IN (3,16,21)
4562: AND party.cle_id = lines.id

Line 10425: FROM OKC_CONTACTS_V

10421: cr_ptrl_det Cur_PTRLDet%rowtype;
10422: -------------------------------------------------
10423: CURSOR Cur_contactDet(P_cpl_id IN NUMBER) IS
10424: SELECT ID
10425: FROM OKC_CONTACTS_V
10426: WHERE cpl_id=P_cpl_Id;
10427: -------------------------------------------------
10428: CURSOR Cur_childline_br(P_cle_Id IN NUMBER) IS
10429: SELECT ID