APPS.LNS_LOAN_HEADER_PUB dependencies on LNS_LOAN_PRODUCT_LINES

Line 82: lns_loan_product_lines prod_line

78:
79: CURSOR c_subsidy_rate (p_loan_id number) IS
80: SELECT disb_percent
81: FROM
82: lns_loan_product_lines prod_line
83: WHERE prod_line.LOAN_PRODUCT_ID = p_loan_header_rec.product_id
84: AND prod_line.LOAN_PRODUCT_LINE_TYPE = 'SUBSIDY_RATE'
85: AND nvl(p_loan_header_rec.gl_date, sysdate) between prod_line.START_DATE_ACTIVE and nvl(prod_line.END_DATE_ACTIVE,nvl(p_loan_header_rec.gl_date, sysdate))
86: AND rownum =1;