APPS.LNS_FUNDING_PUB dependencies on DUAL

Line 3725: select AP_INVOICES_INTERFACE_S.NEXTVAL from dual;

3721: disb_header_id = P_DISB_HEADER_ID;
3722:
3723: -- generating new invoice id
3724: CURSOR new_inv_id_cur IS
3725: select AP_INVOICES_INTERFACE_S.NEXTVAL from dual;
3726:
3727: -- generating new invoice line id
3728: CURSOR new_inv_ln_id_cur IS
3729: select AP_INVOICE_LINES_INTERFACE_S.NEXTVAL from dual;

Line 3729: select AP_INVOICE_LINES_INTERFACE_S.NEXTVAL from dual;

3725: select AP_INVOICES_INTERFACE_S.NEXTVAL from dual;
3726:
3727: -- generating new invoice line id
3728: CURSOR new_inv_ln_id_cur IS
3729: select AP_INVOICE_LINES_INTERFACE_S.NEXTVAL from dual;
3730:
3731: -- get rejection description
3732: CURSOR get_reject_cur(P_CODE VARCHAR2) IS
3733: select description

Line 5271: from dual;

5267: where DISB_HEADER_ID = P_DISB_HEADER_ID)
5268: -
5269: (select count(1) from LNS_DISB_LINES
5270: where DISB_HEADER_ID = P_DISB_HEADER_ID and (STATUS is not null and STATUS = 'FULLY_FUNDED'))
5271: from dual;
5272:
5273: -- getting sum of all disbursed amount for this loan from ap_invoices_all - real situation
5274: CURSOR disb_amount_cur(P_LOAN_ID number) IS
5275: select nvl(sum(inv.amount_paid), 0)