DBA Data[Home] [Help]

APPS.LNS_FINANCIALS dependencies on LNS_CUSTOM_PAYMNT_SCHEDS

Line 580: from lns_custom_paymnt_scheds

576: ,nvl(interest_amount, 0) interest_amount
577: ,nvl(other_amount, 0) other_amount
578: ,nvl(installment_begin_balance, 0) begin_balance
579: ,nvl(installment_end_balance, 0) end_balance
580: from lns_custom_paymnt_scheds
581: where loan_id = p_loan_id
582: order by payment_number;
583:
584: -- bug # 4258345

Line 1191: from lns_custom_paymnt_scheds

1187:
1188: cursor c_customSchedule(p_loan_id number, p_installment number) is
1189: select payment_number installment_number
1190: ,due_date due_date
1191: from lns_custom_paymnt_scheds
1192: where loan_id = p_loan_id
1193: and payment_number = p_installment;
1194:
1195: begin

Line 1668: from LNS_CUSTOM_PAYMNT_SCHEDS cust

1664: ,nvl(cust.INTEREST_AMOUNT, 0)
1665: ,cust.installment_begin_balance
1666: ,cust.installment_end_balance
1667: --cust.FEE_AMOUNT
1668: from LNS_CUSTOM_PAYMNT_SCHEDS cust
1669: where cust.LOAN_ID = P_LOAN_ID and
1670: cust.PAYMENT_NUMBER = P_PAYMENT_NUMBER;
1671:
1672: begin