APPS.LNS_LOAN_LINE_PUB dependencies on DUAL

Line 250: from dual

246: l_bulk_process VARCHAR2(1);
247:
248: CURSOR c_check_existing_line(pLoanId Number) IS
249: select 'Y' line_exists
250: from dual
251: where exists
252: (select null from lns_loan_lines where loan_id = pLoanId and end_date is null);
253:
254: CURSOR c_loan_product(pLoanProductId Number, pOrgId Number) IS