APPS.JAI_AP_UTILS_PKG dependencies on DUAL

Line 84: FROM DUAL;

80: AND pv.vendor_id = jibh.vendor_id;
81:
82: CURSOR for_invoice_num IS
83: SELECT 'PLA/Invoice/'||TO_CHAR(p_org_id) inv_num
84: FROM DUAL;
85:
86: /* Bug 4928860. Added by Lakshmi Gopalsami
87: Removed select and added cursor.
88: */

Line 146: From dual;

142: END IF;
143:
144: Select ap_invoices_interface_s.nextval
145: Into inv_interface_id
146: From dual;
147:
148: SELECT ap_invoice_lines_interface_s.NEXTVAL
149: INTO inv_line_interface_id
150: FROM DUAL;

Line 150: FROM DUAL;

146: From dual;
147:
148: SELECT ap_invoice_lines_interface_s.NEXTVAL
149: INTO inv_line_interface_id
150: FROM DUAL;
151:
152: Select currency_code
153: Into p_currency_code
154: From gl_sets_of_books

Line 347: FROM DUAL; --Added on 21-Feb-2002

343: WHERE invoice_id = inv_id;
344:
345: CURSOR for_invoice_num IS
346: SELECT 'BOE/Invoice/'||TO_CHAR(p_org_id)||'/'||TO_CHAR(P_BOE_ID) inv_num
347: FROM DUAL; --Added on 21-Feb-2002
348:
349: /* Bug 4928860. Added by Lakshmi Gopalsami
350: Removed select and added cursor.
351: */

Line 427: FROM dual;

423: END IF;
424:
425: SELECT ap_invoices_interface_s.NEXTVAL
426: INTO inv_interface_id
427: FROM dual;
428:
429: SELECT ap_invoice_lines_interface_s.NEXTVAL
430: INTO inv_line_interface_id
431: FROM DUAL;

Line 431: FROM DUAL;

427: FROM dual;
428:
429: SELECT ap_invoice_lines_interface_s.NEXTVAL
430: INTO inv_line_interface_id
431: FROM DUAL;
432:
433: SELECT currency_code
434: INTO p_currency_code
435: FROM gl_sets_of_books