APPS.LNS_CUSTOM_PUB dependencies on LNS_LOAN_LINES

Line 2235: 'ERS', (select count(1) from lns_loan_lines where loan_id = p_loan_id and (status is null or status = 'PENDING') and end_date is null))

2231:
2232: cursor c_fund_sched_exist(p_loan_id number) is
2233: select decode(loan.loan_class_code,
2234: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),
2235: 'ERS', (select count(1) from lns_loan_lines where loan_id = p_loan_id and (status is null or status = 'PENDING') and end_date is null))
2236: from lns_loan_headers_all loan
2237: where loan.loan_id = p_loan_id;
2238:
2239: cursor c_get_bill_opt(p_loan_id number) is