APPS.LNS_LOAN_LINE_PUB dependencies on FUN_RULE_BULK_RESULT_GT

Line 298: FUN_RULE_BULK_RESULT_GT results,

294: inv.AMOUNT_DUE_REMAINING,
295: inv.TERMS_SEQUENCE_NUMBER
296: FROM
297: LNS_OPEN_RECEIVABLES_V inv,
298: FUN_RULE_BULK_RESULT_GT results,
299: FUN_RULE_DETAILS rules
300: WHERE inv.payment_schedule_id = results.id
301: AND rules.RULE_DETAIL_ID = results.RULE_DETAIL_ID
302: AND results.RULE_DETAIL_ID <> -99

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: */

Line 322: FUN_RULE_BULK_RESULT_GT results

318: inv.AMOUNT_DUE_REMAINING,
319: inv.TERMS_SEQUENCE_NUMBER
320: FROM
321: LNS_OPEN_RECEIVABLES_V inv,
322: FUN_RULE_BULK_RESULT_GT results
323: WHERE inv.payment_schedule_id = results.id
324: AND results.RULE_DETAIL_ID <> -99;
325:
326: CURSOR c_all_open_invoices_nosort(pPartyId NUMBER, pOrgId NUMBER, pCurrencyCode VARCHAR2) IS