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;