APPS.LNS_LOAN_LINE_PUB dependencies on LNS_OPEN_RECEIVABLES_V

Line 290: LNS_OPEN_RECEIVABLES_V inv,

286: inv.trx_number,
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

Line 314: LNS_OPEN_RECEIVABLES_V inv,

310: inv.AMOUNT_DUE_REMAINING reference_amount,
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:

Line 327: LNS_OPEN_RECEIVABLES_V inv

323: inv.AMOUNT_DUE_REMAINING reference_amount,
324: inv.AMOUNT_DUE_REMAINING,
325: inv.TERMS_SEQUENCE_NUMBER
326: FROM
327: LNS_OPEN_RECEIVABLES_V inv
328: WHERE inv.party_id = pPartyId
329: AND inv.org_id = pOrgId
330: AND inv.invoice_currency_code = pCurrencyCode;
331:

Line 468: p_param_view_name => 'LNS_OPEN_RECEIVABLES_V',

464: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ': ' || 'LNS_LOAN_LINE_PUB.LNS_LOAN_ORG_ID = ' || LNS_LOAN_LINE_PUB.LNS_LOAN_ORG_ID);
465: l_last_api_called := 'FUN_RULE_PUB.apply_rule_bulk';
466: FUN_RULE_PUB.apply_rule_bulk(p_application_short_name => 'LNS',
467: p_rule_object_name => 'LNS_ERS_LOAN_PRODUCT',
468: p_param_view_name => 'LNS_OPEN_RECEIVABLES_V',
469: p_additional_where_clause => 'PARTY_ID = LNS_LOAN_LINE_PUB.GET_LOAN_PARTY_ID AND INVOICE_CURRENCY_CODE = LNS_LOAN_LINE_PUB.GET_LOAN_CURRENCY_CODE AND ORG_ID = LNS_LOAN_LINE_PUB.GET_LOAN_ORG_ID',
470: p_primary_key_column_name => 'PAYMENT_SCHEDULE_ID'
471: );
472: