APPS.LNS_LOAN_LINE_PUB dependencies on FUN_RULE_BULK_RESULT_GT

Line 291: FUN_RULE_BULK_RESULT_GT results,

287: inv.AMOUNT_DUE_REMAINING,
288: inv.TERMS_SEQUENCE_NUMBER
289: FROM
290: LNS_OPEN_RECEIVABLES_V inv,
291: FUN_RULE_BULK_RESULT_GT results,
292: FUN_RULE_DETAILS rules
293: WHERE inv.payment_schedule_id = results.id
294: AND rules.RULE_DETAIL_ID = results.RULE_DETAIL_ID
295: AND results.RULE_DETAIL_ID <> -99

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

Line 315: FUN_RULE_BULK_RESULT_GT results

311: inv.AMOUNT_DUE_REMAINING,
312: inv.TERMS_SEQUENCE_NUMBER
313: FROM
314: LNS_OPEN_RECEIVABLES_V inv,
315: FUN_RULE_BULK_RESULT_GT results
316: WHERE inv.payment_schedule_id = results.id
317: AND results.RULE_DETAIL_ID <> -99;
318:
319: CURSOR c_all_open_invoices_nosort(pPartyId NUMBER, pOrgId NUMBER, pCurrencyCode VARCHAR2) IS