DBA Data[Home] [Help]

APPS.LNS_REP_UTILS dependencies on LNS_PAY_SUM_V

Line 305: 'LNS_PAY_SUM_V pay, ' ||

301: 'lns_loan_headers_all_vl lh, ' ||
302: 'hz_parties hp, ' ||
303: 'lns_terms t, ' ||
304: 'lns_lookups llk, ' ||
305: 'LNS_PAY_SUM_V pay, ' ||
306: 'hz_cust_accounts_all account, ' ||
307: 'lns_lookups llkrt, ' ||
308: 'lns_lookups llktt, ' ||
309: 'lns_lookups llks ' ||

Line 846: 'LNS_PAY_SUM_V pay, ' ||

842: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
843: ' from dual) dateparameters, ' ||
844: 'hz_parties hp, ' ||
845: 'lns_lookups llk, ' ||
846: 'LNS_PAY_SUM_V pay, ' ||
847: 'hz_cust_accounts_all account, ' ||
848: 'hz_locations loc, ' ||
849: 'fnd_territories_vl terr, ' ||
850: 'hz_party_sites site, ' ||

Line 1170: from LNS_PAY_SUM_V pay

1166: --Bug5262505 --karamach
1167: l_total_principal_balance NUMBER;
1168: CURSOR c_get_principal_balance(pLoanId Number) IS
1169: select pay.TOTAL_PRINCIPAL_BALANCE loan_amount
1170: from LNS_PAY_SUM_V pay
1171: where pay.loan_id = pLoanId;
1172:
1173: CURSOR C_agreement (X_Loan_Id NUMBER
1174: ,pTotalPrincipalBalance Number) IS

Line 1642: --LNS_PAY_SUM_V pay, --Bug5262505

1638: hz_locations loc,
1639: fnd_territories_tl terr,
1640: hz_party_sites site,
1641: hz_cust_acct_sites_all acct_site,
1642: --LNS_PAY_SUM_V pay, --Bug5262505
1643: xle_firstparty_information_v xle,
1644: lns_lookups llkrt,
1645: lns_lookups llktt,
1646: lns_loan_types_vl llt,