APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_PRODUCTS

Line 70: lns_loan_products p

66: select nvl(p.BDGT_REQ_FOR_APPR_FLAG, 'Y')
67: ,nvl(h.funds_reserved_flag, 'N')
68: ,nvl(h.gl_date, sysdate)
69: from lns_loan_headers h,
70: lns_loan_products p
71: where p.loan_product_id = h.product_id
72: and h.loan_id = p_loan_id;
73:
74: cursor c_obj_vers(p_loan_id number) is

Line 410: lns_loan_products p

406: select nvl(p.BDGT_REQ_FOR_APPR_FLAG, 'Y')
407: ,nvl(h.funds_reserved_flag, 'N')
408: ,nvl(h.gl_date, sysdate)
409: from lns_loan_headers h,
410: lns_loan_products p
411: where p.loan_product_id = h.product_id
412: and h.loan_id = p_loan_id;
413:
414: -- get budgetary control events only