APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOAN_TYPES_VL

Line 3248: select LOAN_TYPE_NAME from LNS_LOAN_TYPES_VL where LOAN_TYPE_ID = P_TYPE_ID;

3244: select LOAN_PRODUCT_NAME from lns_loan_products_vl where LOAN_PRODUCT_ID = P_PRODUCT_ID;
3245:
3246: /* query for loan type name */
3247: CURSOR loan_type_cur(P_TYPE_ID number) IS
3248: select LOAN_TYPE_NAME from LNS_LOAN_TYPES_VL where LOAN_TYPE_ID = P_TYPE_ID;
3249:
3250: BEGIN
3251:
3252: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');

Line 3572: 'lns_loan_types_vl loan_type, ' ||

3568: 'hz_cust_acct_sites_all acct_site, ' ||
3569: 'hz_party_sites site, ' ||
3570: 'fnd_currencies_tl curr, ' ||
3571: 'hz_parties contact_person, ' ||
3572: 'lns_loan_types_vl loan_type, ' ||
3573: 'lns_lookups loan_class, ' ||
3574: 'lns_lookups periodlkup, ' ||
3575: 'lns_lookups loan_subtype, ' ||
3576: 'lns_terms terms, ' ||