APPS.OKC_WF_K_APPROVE dependencies on OKC_K_REL_OBJS

Line 550: from OKC_K_REL_OBJS_V R, ASO_Quote_Headers_ALL Q

546: L1 varchar2(1):='F';
547: /* commented by GunA
548: cursor c1 is
549: select 'T'
550: from OKC_K_REL_OBJS_V R, ASO_Quote_Headers_ALL Q
551: where R.chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
552: -- and R.RTY_CODE = 'CONTRACTNEGOTIATESQUOTE'
553: and R.RTY_CODE like 'CONTRACT%IS%TERM%FOR%QUOTE'
554: and R.CLE_ID IS NULL

Line 562: from okc_k_rel_objs

558: /* Cursor to check contracts in IStore and Quotation */
559: -- Bug#2208391 - added check of profile option 'OKC_CREATE_ORDER_FROM_K'
560: CURSOR c1 is
561: select 'T'
562: from okc_k_rel_objs
563: where chr_id = wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTRACT_ID')
564: and JTOT_OBJECT1_CODE = G_OBJECT_CODE
565: ---and RTY_CODE = G_TERMSFORQUOTE ;
566: -- and RTY_CODE in (G_TERMSFORQUOTE, G_NEGOTIATESQUOTE);