DBA Data[Home] [Help]

APPS.FUN_AP_TRANSFER dependencies on DUAL

Line 255: select sysdate into l_init_sysdate from dual;

251: ELSE
252: l_run_payables_import :='No';
253: END IF;
254:
255: select sysdate into l_init_sysdate from dual;
256:
257: l_request_id := fnd_global.conc_request_id;
258:
259: IF (p_org_id is not null) THEN

Line 587: FROM dual;

583: AND site.org_id = p_org_id;
584: OPEN c_dist;
585:
586: SELECT ap_invoices_interface_s.nextval INTO l_invoice_id
587: FROM dual;
588:
589: LOOP
590: FETCH c_dist INTO l_d_amount_cr, l_d_amount_dr, l_ccid,
591: l_dist_type, l_l_amount_cr, l_l_amount_dr,

Line 699: FROM dual;

695: l_amount := l_d_amount_cr * (-1);
696: END IF;
697:
698: SELECT ap_invoice_lines_interface_s.nextval into l_inv_line_id
699: FROM dual;
700:
701: -- Bug 9734156 Mapped Dist Number to line number
702:
703: INSERT INTO ap_invoice_lines_interface (