APPS.LNS_LOAN_LINE_PUB dependencies on FUN_RULE_OBJ_ATTRIBUTES

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

Line 300: FUN_RULE_OBJ_ATTRIBUTES attr, FUN_RULE_DETAILS rule, FUN_RULE_BULK_RESULT_GT gt

296: ORDER BY rules.SEQ, pSortAttribute;
297:
298: /* -- pSortAttribute
299: (select DEFAULT_VALUE from
300: FUN_RULE_OBJ_ATTRIBUTES attr, FUN_RULE_DETAILS rule, FUN_RULE_BULK_RESULT_GT gt
301: where attr.RULE_OBJECT_ID = rule.rule_object_id
302: and rule.rule_detail_id = gt.rule_detail_id
303: and rownum < 2);
304: */