APPS.OKS_WF_K_APPROVE dependencies on OKC_K_REL_OBJS

Line 741: from OKC_K_REL_OBJS_V R, ASO_Quote_Headers_ALL Q

737: L1 varchar2(1):='F';
738: /* commented by GunA
739: cursor c1 is
740: select 'T'
741: from OKC_K_REL_OBJS_V R, ASO_Quote_Headers_ALL Q
742: where R.chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
743: -- and R.RTY_CODE = 'CONTRACTNEGOTIATESQUOTE'
744: and R.RTY_CODE like 'CONTRACT%IS%TERM%FOR%QUOTE'
745: and R.CLE_ID IS NULL

Line 753: from okc_k_rel_objs

749: /* Cursor to check contracts in IStore and Quotation */
750: -- Bug#2208391 - added check of profile option 'OKC_CREATE_ORDER_FROM_K'
751: CURSOR c1 is
752: select 'T'
753: from okc_k_rel_objs
754: where chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
755: and JTOT_OBJECT1_CODE = G_OBJECT_CODE
756: ---and RTY_CODE = G_TERMSFORQUOTE ;
757: -- and RTY_CODE in (G_TERMSFORQUOTE, G_NEGOTIATESQUOTE);