APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_K_GRPINGS

Line 19347: FROM Okc_K_grpings grpng

19343: -- where clause for contract group added dtd Dec 17th, 2003
19344: AND (Cv_contract_grp_id is null
19345: OR
19346: EXISTS (SELECT 'x'
19347: FROM Okc_K_grpings grpng
19348: WHERE grpng.included_chr_id = b.id
19349: and grpng.cgp_parent_id = Cv_contract_grp_id ));
19350: -- and nvl(b.renewal_type_code,'#') = nvl(Cv_cont_renewal_code,nvl(b.renewal_type_code,'#'))
19351: /*Added for Bug:6767455

Line 19416: FROM Okc_K_grpings grpng

19412: AND PR.RLE_CODE not in ('VENDOR','MERCHANT'))) ---Modified condition for ER9681794
19413: AND (Cv_contract_grp_id is null
19414: OR
19415: EXISTS (SELECT 'x'
19416: FROM Okc_K_grpings grpng
19417: WHERE grpng.included_chr_id = b.id
19418: and grpng.cgp_parent_id = Cv_contract_grp_id ));
19419:
19420: CURSOR Lx_Csr_Party_Contracts(Cv_Contract_Num IN VARCHAR2,

Line 19524: Okc_K_grpings grpng

19520: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19521: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19522: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19523: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19524: Okc_K_grpings grpng
19525: WHERE grpng.cgp_parent_id = Cv_contract_grp_id
19526: AND B.ID = grpng.included_chr_id
19527: -- AND Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
19528: -- AND ( (Cv_Contract_Num_Modifier IS NULL)

Line 19562: Okc_K_grpings grpng,

19558: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19559: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19560:
19561: FROM Okc_K_Party_Roles_B PR,
19562: Okc_K_grpings grpng,
19563: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19564: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19565:
19566: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 19609: Okc_K_grpings grpng,

19605: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19606: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19607:
19608: FROM Okc_K_Party_Roles_B PR,
19609: Okc_K_grpings grpng,
19610: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19611: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19612:
19613: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 19699: FROM Okc_K_grpings grpng

19695: AND PR.RLE_CODE <> 'VENDOR'))
19696: AND (Cv_contract_grp_id is null -- Where clause for contract group added dtd Dec 17th, 2003
19697: OR
19698: EXISTS (SELECT 'x'
19699: FROM Okc_K_grpings grpng
19700: WHERE grpng.included_chr_id = b.id
19701: AND grpng.cgp_parent_id = Cv_contract_grp_id ));
19702:
19703:

Line 19763: FROM Okc_K_grpings grpng

19759: AND PR.RLE_CODE not in ('VENDOR','MERCHANT'))) ---Modified condition for ER9681794
19760: AND (Cv_contract_grp_id is null -- Where clause for contract group added dtd Dec 17th, 2003
19761: OR
19762: EXISTS (SELECT 'x'
19763: FROM Okc_K_grpings grpng
19764: WHERE grpng.included_chr_id = b.id
19765: AND grpng.cgp_parent_id = Cv_contract_grp_id ));
19766: /*Added for Bug:6767455*/
19767:

Line 19826: FROM Okc_K_grpings grpng

19822: -- where clause for contract group added dtd Dec 17th, 2003
19823: AND (Cv_contract_grp_id is null
19824: OR
19825: EXISTS (SELECT 'x'
19826: FROM Okc_K_grpings grpng
19827: WHERE grpng.included_chr_id = b.id
19828: and grpng.cgp_parent_id = Cv_contract_grp_id ));
19829: /*commented for bug:6767455
19830: -- and nvl(b.renewal_type_code,'#') = nvl(Cv_cont_renewal_code,nvl(b.renewal_type_code,'#'))

Line 19888: FROM Okc_K_grpings grpng

19884: AND PR.RLE_CODE not in ('VENDOR','MERCHANT'))) ---Modified condition for ER9681794
19885: AND (Cv_contract_grp_id is null
19886: OR
19887: EXISTS (SELECT 'x'
19888: FROM Okc_K_grpings grpng
19889: WHERE grpng.included_chr_id = b.id
19890: and grpng.cgp_parent_id = Cv_contract_grp_id ));
19891:
19892: