APPS.LNS_REP_UTILS dependencies on LNS_LOAN_LINES

Line 271: 'from LNS_LOAN_LINES ' ||

267: ', CURSOR (select ' ||
268: 'REQUESTED_AMOUNT loan_requested_amount, ' ||
269: 'REFERENCE_AMOUNT original_rec_balance, ' ||
270: 'REFERENCE_NUMBER original_rec_desc ' ||
271: 'from LNS_LOAN_LINES ' ||
272: 'where loan_id = lh.LOAN_ID ' ||
273: 'and end_date is null ) AS ORIGINAL_RECEIVABLES ' ||
274: 'from ' ||
275: 'lns_loan_headers_all lh, ' ||

Line 617: ' from LNS_LOAN_LINES ' ||

613: ' REFERENCE_NUMBER original_rec_number, ' ||
614: ' REFERENCE_AMOUNT original_rec_balance, ' ||
615: ' REQUESTED_AMOUNT loan_requested_amount, ' ||
616: ' REFERENCE_NUMBER original_rec_desc ' ||
617: ' from LNS_LOAN_LINES ' ||
618: ' where loan_id = lh.LOAN_ID ' ||
619: ' and end_date is null ' ||
620: ') AS ORIGINAL_RECEIVABLES ' ||
621: ', CURSOR ( ' ||

Line 1375: from LNS_LOAN_LINES lll,

1371: )
1372: )
1373: )
1374: )
1375: from LNS_LOAN_LINES lll,
1376: RA_CUSTOMER_TRX_ALL cust_trx,
1377: RA_CUST_TRX_TYPES_ALL trx_type,
1378: ar_lookups trx_type_lkup
1379: where lll.loan_id = lh.LOAN_ID and