APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_RULE_GROUPS_B

Line 226: OKC_RULE_GROUPS_B RGP

222: p_line_id IN NUMBER)
223: IS
224: SELECT RUL.RULE_INFORMATION11
225: FROM OKC_RULES_B RUL,
226: OKC_RULE_GROUPS_B RGP
227: WHERE RUL.RGP_ID = RGP.ID
228: AND RGP.DNZ_CHR_ID = p_contract_id
229: AND RGP.CLE_ID = p_line_id
230: AND RUL.RULE_INFORMATION_CATEGORY = 'LAASTX'

Line 237: OKC_RULE_GROUPS_B RGP

233: CURSOR c_asset_upfront_tax(p_contract_id IN NUMBER)
234: IS
235: SELECT RUL.RULE_INFORMATION1
236: FROM OKC_RULES_B RUL,
237: OKC_RULE_GROUPS_B RGP
238: WHERE RUL.RGP_ID = RGP.ID
239: AND RGP.DNZ_CHR_ID = p_contract_id
240: AND RUL.RULE_INFORMATION_CATEGORY = 'LASTPR'
241: AND RGP.RGD_CODE = 'LAHDTX';