APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_K_GRPINGS

Line 17503: FROM Okc_K_grpings grpng

17499: -- where clause for contract group added dtd Dec 17th, 2003
17500: AND (Cv_contract_grp_id is null
17501: OR
17502: EXISTS (SELECT 'x'
17503: FROM Okc_K_grpings grpng
17504: WHERE grpng.included_chr_id = b.id
17505: and grpng.cgp_parent_id = Cv_contract_grp_id ));
17506: -- and nvl(b.renewal_type_code,'#') = nvl(Cv_cont_renewal_code,nvl(b.renewal_type_code,'#'))
17507: /*Added for Bug:6767455

Line 17583: Okc_K_grpings grpng

17579: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17580: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17581: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17582: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
17583: Okc_K_grpings grpng
17584: WHERE grpng.cgp_parent_id = Cv_contract_grp_id
17585: AND B.ID = grpng.included_chr_id
17586: -- AND Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
17587: -- AND ( (Cv_Contract_Num_Modifier IS NULL)

Line 17621: Okc_K_grpings grpng,

17617: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17618: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17619:
17620: FROM Okc_K_Party_Roles_B PR,
17621: Okc_K_grpings grpng,
17622: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17623: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17624:
17625: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 17710: FROM Okc_K_grpings grpng

17706: AND PR.RLE_CODE <> 'VENDOR'))
17707: AND (Cv_contract_grp_id is null -- Where clause for contract group added dtd Dec 17th, 2003
17708: OR
17709: EXISTS (SELECT 'x'
17710: FROM Okc_K_grpings grpng
17711: WHERE grpng.included_chr_id = b.id
17712: AND grpng.cgp_parent_id = Cv_contract_grp_id ));
17713: /*Added for Bug:6767455*/
17714: CURSOR Lx_Csr_ContractNum_Contracts(Cv_Contract_Num IN VARCHAR2,

Line 17772: FROM Okc_K_grpings grpng

17768: -- where clause for contract group added dtd Dec 17th, 2003
17769: AND (Cv_contract_grp_id is null
17770: OR
17771: EXISTS (SELECT 'x'
17772: FROM Okc_K_grpings grpng
17773: WHERE grpng.included_chr_id = b.id
17774: and grpng.cgp_parent_id = Cv_contract_grp_id ));
17775: /*commented for bug:6767455
17776: -- and nvl(b.renewal_type_code,'#') = nvl(Cv_cont_renewal_code,nvl(b.renewal_type_code,'#'))