APPS.LNS_REP_UTILS dependencies on LNS_LOAN_LINES

Line 297: 'from LNS_LOAN_LINES ' ||

293: ', CURSOR (select ' ||
294: 'REQUESTED_AMOUNT loan_requested_amount, ' ||
295: 'REFERENCE_AMOUNT original_rec_balance, ' ||
296: 'REFERENCE_NUMBER original_rec_desc ' ||
297: 'from LNS_LOAN_LINES ' ||
298: 'where loan_id = lh.LOAN_ID ' ||
299: 'and end_date is null) AS ORIGINAL_RECEIVABLES ' ||
300: 'from ' ||
301: 'lns_loan_headers_all_vl lh, ' ||

Line 680: ' from LNS_LOAN_LINES ' ||

676: ' REFERENCE_NUMBER original_rec_number, ' ||
677: ' REFERENCE_AMOUNT original_rec_balance, ' ||
678: ' REQUESTED_AMOUNT loan_requested_amount, ' ||
679: ' REFERENCE_NUMBER original_rec_desc ' ||
680: ' from LNS_LOAN_LINES ' ||
681: ' where loan_id = lh.LOAN_ID ' ||
682: ' and end_date is null ' ||
683: ') AS ORIGINAL_RECEIVABLES ' ||
684: ', CURSOR ( ' ||

Line 1469: from LNS_LOAN_LINES lll,

1465: )
1466: )
1467: )
1468: )
1469: from LNS_LOAN_LINES lll,
1470: RA_CUSTOMER_TRX_ALL cust_trx,
1471: RA_CUST_TRX_TYPES_ALL trx_type,
1472: ar_lookups trx_type_lkup
1473: where lll.loan_id = lh.LOAN_ID and