APPS.OKS_WF_K_APPROVE dependencies on OKC_K_REL_OBJS

Line 790: from OKC_K_REL_OBJS_V R, ASO_Quote_Headers_ALL Q

786: L1 varchar2(1):='F';
787: /* commented by GunA
788: cursor c1 is
789: select 'T'
790: from OKC_K_REL_OBJS_V R, ASO_Quote_Headers_ALL Q
791: where R.chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
792: -- and R.RTY_CODE = 'CONTRACTNEGOTIATESQUOTE'
793: and R.RTY_CODE like 'CONTRACT%IS%TERM%FOR%QUOTE'
794: and R.CLE_ID IS NULL

Line 802: from okc_k_rel_objs

798: /* Cursor to check contracts in IStore and Quotation */
799: -- Bug#2208391 - added check of profile option 'OKC_CREATE_ORDER_FROM_K'
800: CURSOR c1 is
801: select 'T'
802: from okc_k_rel_objs
803: where chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
804: and JTOT_OBJECT1_CODE = G_OBJECT_CODE
805: ---and RTY_CODE = G_TERMSFORQUOTE ;
806: -- and RTY_CODE in (G_TERMSFORQUOTE, G_NEGOTIATESQUOTE);