APPS.LNS_APPL_ENGINE_PUB dependencies on LNS_LOAN_HEADERS

Line 190: select loan_number from lns_loan_headers where loan_id = P_LOAN_ID;

186: select LOAN_PRODUCT_NAME from lns_loan_products_vl where loan_product_id = P_PRODUCT_ID;
187:
188: /* query for loan number */
189: CURSOR loan_cur(P_LOAN_ID number) IS
190: select loan_number from lns_loan_headers where loan_id = P_LOAN_ID;
191:
192: /* query for flag meaning */
193: CURSOR unapply_flag_cur(P_UNAPPLY_FLAG varchar2) IS
194: select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = P_UNAPPLY_FLAG;

Line 1273: lns_loan_headers loan,

1269: psa.invoice_currency_code,
1270: party.party_name
1271: from
1272: lns_participants par,
1273: lns_loan_headers loan,
1274: hz_cust_accounts cust,
1275: ar_payment_schedules psa,
1276: lns_system_options sys,
1277: gl_sets_of_books books,

Line 1463: lns_loan_headers loan,

1459: psa.invoice_currency_code,
1460: loan.EXCHANGE_RATE
1461: from
1462: lns_amortization_scheds am,
1463: lns_loan_headers loan,
1464: ar_payment_schedules psa,
1465: hz_parties party,
1466: lns_loan_products_vl product,
1467: lns_lookups look

Line 1506: lns_loan_headers loan,

1502: psa.invoice_currency_code,
1503: loan.EXCHANGE_RATE
1504: from
1505: lns_amortization_scheds am,
1506: lns_loan_headers loan,
1507: ar_payment_schedules psa,
1508: hz_parties party,
1509: lns_loan_products_vl product,
1510: lns_lookups look

Line 1791: from lns_loan_headers loan,

1787: party.party_name,
1788: loan.product_id,
1789: product.loan_product_name,
1790: loan.loan_currency
1791: from lns_loan_headers loan,
1792: hz_parties party,
1793: lns_loan_products_vl product
1794: where
1795: loan.primary_borrower_id = nvl(P_BORROWER_ID, loan.primary_borrower_id) and