APPS.LNS_LOAN_LINE_PUB dependencies on LNS_OPEN_RECEIVABLES_V

Line 297: LNS_OPEN_RECEIVABLES_V inv,

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

Line 321: LNS_OPEN_RECEIVABLES_V inv,

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

Line 334: LNS_OPEN_RECEIVABLES_V inv

330: inv.AMOUNT_DUE_REMAINING reference_amount,
331: inv.AMOUNT_DUE_REMAINING,
332: inv.TERMS_SEQUENCE_NUMBER
333: FROM
334: LNS_OPEN_RECEIVABLES_V inv
335: WHERE inv.party_id = pPartyId
336: AND inv.org_id = pOrgId
337: AND inv.invoice_currency_code = pCurrencyCode;
338:

Line 475: p_param_view_name => 'LNS_OPEN_RECEIVABLES_V',

471: 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);
472: l_last_api_called := 'FUN_RULE_PUB.apply_rule_bulk';
473: FUN_RULE_PUB.apply_rule_bulk(p_application_short_name => 'LNS',
474: p_rule_object_name => 'LNS_ERS_LOAN_PRODUCT',
475: p_param_view_name => 'LNS_OPEN_RECEIVABLES_V',
476: 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',
477: p_primary_key_column_name => 'PAYMENT_SCHEDULE_ID'
478: );
479: