DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_RULE_GROUPS_B

Line 194: OKC_RULE_GROUPS_B RGP

190: p_line_id IN NUMBER)
191: IS
192: SELECT RUL.RULE_INFORMATION11
193: FROM OKC_RULES_B RUL,
194: OKC_RULE_GROUPS_B RGP
195: WHERE RUL.RGP_ID = RGP.ID
196: AND RGP.DNZ_CHR_ID = p_contract_id
197: AND RGP.CLE_ID = p_line_id
198: AND RUL.RULE_INFORMATION_CATEGORY = 'LAASTX'

Line 205: OKC_RULE_GROUPS_B RGP

201: CURSOR c_asset_upfront_tax(p_contract_id IN NUMBER)
202: IS
203: SELECT RUL.RULE_INFORMATION1
204: FROM OKC_RULES_B RUL,
205: OKC_RULE_GROUPS_B RGP
206: WHERE RUL.RGP_ID = RGP.ID
207: AND RGP.DNZ_CHR_ID = p_contract_id
208: AND RUL.RULE_INFORMATION_CATEGORY = 'LASTPR'
209: AND RGP.RGD_CODE = 'LAHDTX';