APPS.LNS_LOAN_LINE_PUB dependencies on FUN_RULE_OBJ_ATTRIBUTES

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

Line 307: FUN_RULE_OBJ_ATTRIBUTES attr, FUN_RULE_DETAILS rule, FUN_RULE_BULK_RESULT_GT gt

303: ORDER BY rules.SEQ, pSortAttribute;
304:
305: /* -- pSortAttribute
306: (select DEFAULT_VALUE from
307: FUN_RULE_OBJ_ATTRIBUTES attr, FUN_RULE_DETAILS rule, FUN_RULE_BULK_RESULT_GT gt
308: where attr.RULE_OBJECT_ID = rule.rule_object_id
309: and rule.rule_detail_id = gt.rule_detail_id
310: and rownum < 2);
311: */