DBA Data[Home] [Help]

APPS.LNS_LOAN_LINE_PUB dependencies on FUN_RULE_OBJECTS_B

Line 275: FUN_RULE_OBJECTS_B obj, FUN_RULE_OBJ_ATTRIBUTES attr

271:
272: CURSOR c_get_rule_object(pRuleObjectName VARCHAR2, pApplicationId NUMBER, pLoanProductId NUMBER, pOrgId NUMBER) IS
273: select 'Y' rule_exists, attr.DEFAULT_VALUE sort_attribute
274: FROM
275: FUN_RULE_OBJECTS_B obj, FUN_RULE_OBJ_ATTRIBUTES attr
276: WHERE obj.RULE_OBJECT_NAME = pRuleObjectName
277: AND obj.application_id = pApplicationId
278: AND obj.instance_label = to_char(pLoanProductId)
279: AND obj.ORG_ID = pOrgId