APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_PRODUCTS

Line 76: lns_loan_products p

72: select nvl(p.BDGT_REQ_FOR_APPR_FLAG, 'N')
73: ,nvl(h.funds_reserved_flag, 'N')
74: ,nvl(h.gl_date, sysdate)
75: from lns_loan_headers h,
76: lns_loan_products p
77: where p.loan_product_id = h.product_id
78: and h.loan_id = p_loan_id;
79:
80: cursor c_obj_vers(p_loan_id number) is

Line 524: lns_loan_products p

520: select nvl(p.BDGT_REQ_FOR_APPR_FLAG, 'N')
521: ,nvl(h.funds_reserved_flag, 'N')
522: ,h.loan_start_date -- fix for bug 16068385
523: from lns_loan_headers h,
524: lns_loan_products p
525: where p.loan_product_id = h.product_id
526: and h.loan_id = p_loan_id;
527:
528: -- get budgetary control events only

Line 5978: lns_loan_products p,

5974: select nvl(p.BDGT_REQ_FOR_APPR_FLAG, 'N')
5975: ,nvl(ladj.funds_reserved_flag, 'N')
5976: ,ladj.EFFECTIVE_DATE -- fix for bug 16068385
5977: from lns_loan_headers h,
5978: lns_loan_products p,
5979: lns_loan_amount_adjs ladj
5980: where p.loan_product_id = h.product_id
5981: and ladj.loan_id = h.loan_id
5982: and ladj.loan_amount_adj_id = c_loan_amount_adj_id;

Line 7659: lns_loan_products p

7655: select nvl(p.BDGT_REQ_FOR_APPR_FLAG, 'N')
7656: ,nvl(h.funds_reserved_flag, 'N')
7657: ,nvl(h.gl_date, sysdate)
7658: from lns_loan_headers h,
7659: lns_loan_products p
7660: where p.loan_product_id = h.product_id
7661: and h.loan_id = p_loan_id;
7662:
7663: cursor c_obj_vers(p_loan_id number) is