APPS.LNS_REP_UTILS dependencies on LNS_LOAN_HEADERS_ALL_VL

Line 301: 'lns_loan_headers_all_vl lh, ' ||

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, ' ||
302: 'hz_parties hp, ' ||
303: 'lns_terms t, ' ||
304: 'lns_lookups llk, ' ||
305: 'LNS_PAY_SUM_V pay, ' ||

Line 840: 'lns_loan_headers_all_vl lh, ' ||

836: ' fund_act.lookup_type(+) = ''DISB_ACTIVITY'' and ' ||
837: ' fund_act.lookup_code(+) = head.ACTIVITY_CODE) ' ||
838: 'AS Disbursement_Schedule ' ||
839: 'from ' ||
840: 'lns_loan_headers_all_vl lh, ' ||
841: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
842: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
843: ' from dual) dateparameters, ' ||
844: 'hz_parties hp, ' ||

Line 1633: lns_loan_headers_all_vl lh,

1629: where agt.loan_id = lh.loan_id
1630: ) -- end of AMORTIZATION
1631: ), XMLFormat.createformat('ROWSET')).getClobVal()
1632: from
1633: lns_loan_headers_all_vl lh,
1634: hz_parties hp,
1635: lns_terms t,
1636: lns_int_rate_headers_vl intrt,
1637: lns_rate_schedules ratesch,

Line 2953: 'from LNS_LOAN_HEADERS_ALL_VL';

2949: 'LOAN_CURRENCY, ' ||
2950: 'ORG_ID, ' ||
2951: 'LEGAL_ENTITY_ID, ' ||
2952: 'LOAN_STATUS ' ||
2953: 'from LNS_LOAN_HEADERS_ALL_VL';
2954:
2955: if ORG_ID is not null then
2956: if l_where is not null then
2957: l_where := l_where || ' and ';