APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOAN_HEADERS_VL

Line 5350: from LNS_LOAN_HEADERS_VL head,

5346: nvl(head.CURRENT_PHASE, 'TERM'),
5347: nvl(head.FORGIVENESS_FLAG, 'N'),
5348: nvl(head.FORGIVENESS_PERCENT, 0),
5349: nvl(head.DISABLE_BILLING_FLAG, 'N')
5350: from LNS_LOAN_HEADERS_VL head,
5351: LNS_TERMS term
5352: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5353: and head.loan_id = term.loan_id
5354: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

Line 6667: from LNS_LOAN_HEADERS_VL head,

6663: nvl(head.CURRENT_PHASE, 'TERM'),
6664: nvl(head.FORGIVENESS_FLAG, 'N'),
6665: nvl(head.FORGIVENESS_PERCENT, 0),
6666: decode(am.AMORTIZATION_SCHEDULE_ID, null, head.FUNDED_AMOUNT, am.FUNDED_AMOUNT)
6667: from LNS_LOAN_HEADERS_VL head,
6668: LNS_TERMS term,
6669: LNS_AMORTIZATION_SCHEDS am
6670: where head.LOAN_ID = P_LOAN_ID
6671: -- Bug#6830765 - Enable billing for all loan status, used in Application fee 'SubmitForApproval Fee'

Line 7592: from LNS_LOAN_HEADERS_VL loan,

7588: trx.legal_entity_id,
7589: lines.REC_ADJUSTMENT_ID,
7590: nvl(lines.installment_number, 1),
7591: loan.LOAN_START_DATE
7592: from LNS_LOAN_HEADERS_VL loan,
7593: RA_CUSTOMER_TRX trx,
7594: ar_payment_schedules psa,
7595: lns_loan_lines lines
7596: where loan.loan_id = P_LOAN_ID and

Line 8408: from LNS_LOAN_HEADERS_VL loan,

8404: psa.GL_DATE,
8405: nvl(loan.CURRENT_PHASE, 'TERM'),
8406: psa.org_id,
8407: loan.LOAN_CURRENCY
8408: from LNS_LOAN_HEADERS_VL loan,
8409: lns_amortization_scheds am,
8410: ar_payment_schedules psa
8411: where
8412: loan.loan_id = P_LOAN_ID and

Line 10939: from LNS_LOAN_HEADERS_VL loan,

10935: trx.org_id,
10936: trx.legal_entity_id,
10937: lines.REC_ADJUSTMENT_ID,
10938: nvl(lines.installment_number, 1)
10939: from LNS_LOAN_HEADERS_VL loan,
10940: RA_CUSTOMER_TRX trx,
10941: ar_payment_schedules psa,
10942: lns_loan_lines lines
10943: where lines.LOAN_LINE_ID = P_LOAN_LINE_ID and