DBA Data[Home] [Help]

APPS.LNS_LOAN_LINE_PUB dependencies on FUN_RULE_OBJECTS_B

Line 282: FUN_RULE_OBJECTS_B obj, FUN_RULE_OBJ_ATTRIBUTES attr

278:
279: CURSOR c_get_rule_object(pRuleObjectName VARCHAR2, pApplicationId NUMBER, pLoanProductId NUMBER, pOrgId NUMBER) IS
280: select 'Y' rule_exists, attr.DEFAULT_VALUE sort_attribute
281: FROM
282: FUN_RULE_OBJECTS_B obj, FUN_RULE_OBJ_ATTRIBUTES attr
283: WHERE obj.RULE_OBJECT_NAME = pRuleObjectName
284: AND obj.application_id = pApplicationId
285: AND obj.instance_label = to_char(pLoanProductId)
286: AND obj.ORG_ID = pOrgId