APPS.OKL_RULE_APIS_PVT dependencies on OKC_RULE_GROUPS_V

Line 33: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

29: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
30: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RGS';
31: l_api_version CONSTANT NUMBER := 1.0;
32: ---------------------------------------------------------------------------
33: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V
34: ---------------------------------------------------------------------------
35: FUNCTION get_rgpv_tab (
36: p_chr_id IN NUMBER,
37: p_cle_id IN NUMBER,

Line 77: FROM Okc_Rule_Groups_V rgpv

73: rgpv.CREATION_DATE,
74: rgpv.LAST_UPDATED_BY,
75: rgpv.LAST_UPDATE_DATE,
76: rgpv.LAST_UPDATE_LOGIN
77: FROM Okc_Rule_Groups_V rgpv
78: WHERE rgpv.chr_id = p_chr_id
79: AND rgpv.dnz_chr_id = p_chr_id
80: AND rgpv.cle_id is NULL
81: AND rgpv.RGD_CODE = decode(p_rgd_code,null,rgpv.RGD_CODE,p_rgd_code);

Line 119: FROM Okc_Rule_Groups_V rgpv

115: rgpv.CREATION_DATE,
116: rgpv.LAST_UPDATED_BY,
117: rgpv.LAST_UPDATE_DATE,
118: rgpv.LAST_UPDATE_LOGIN
119: FROM Okc_Rule_Groups_V rgpv
120: WHERE rgpv.cle_id = p_cle_id
121: AND rgpv.dnz_chr_id = p_chr_id
122: AND rgpv.chr_id is NULL
123: AND rgpv.RGD_CODE = decode(p_rgd_code,null,rgpv.RGD_CODE,p_rgd_code);