APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOAN_PRODUCTS_VL

Line 3244: select LOAN_PRODUCT_NAME from lns_loan_products_vl where LOAN_PRODUCT_ID = P_PRODUCT_ID;

3240: language(+) = userenv('LANG');
3241:
3242: /* query for loan product name */
3243: CURSOR loan_product_cur(P_PRODUCT_ID number) IS
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;

Line 3582: 'lns_loan_products_vl product, ' ||

3578: 'lns_lookups rate_type, ' ||
3579: 'lns_lookups rate_freq, ' ||
3580: 'lns_lookups pay_freq, ' ||
3581: 'fnd_lookups open_to_term, ' ||
3582: 'lns_loan_products_vl product, ' ||
3583: 'lns_rate_schedules rate_sched1, ' ||
3584: 'lns_rate_schedules rate_sched2 ' ||
3585:
3586: 'WHERE party.party_id = loan.primary_borrower_id and ' ||