APPS.JAI_FBT_PAYMENT_P dependencies on DUAL

Line 413: FROM dual;

409: SELECT
410: ap_invoices_interface_s.nextval
411: INTO
412: ln_invoice_id
413: FROM dual;
414:
415: -- get the payment id
416: SELECT jai_fbt_payment_s.NEXTVAL
417: INTO ln_fbt_payment_id

Line 418: FROM dual;

414:
415: -- get the payment id
416: SELECT jai_fbt_payment_s.NEXTVAL
417: INTO ln_fbt_payment_id
418: FROM dual;
419:
420: -- get the org id, accts_pay_code_combination_id, payment_method_lookup_code
421: OPEN po_vendors_cur;
422: FETCH po_vendors_cur

Line 449: FROM dual;

445: AND legal_entity_id = pn_legal_entity_id;
446:
447: SELECT 'FBT/Invoice/'||pn_legal_entity_id||'/'|| TO_CHAR(ld_invoice_date,lv_date_mask)||'/'|| pn_invoice_number_seq
448: INTO ln_invoice_num
449: FROM dual;
450:
451: -- insert the data into the table jai_fbt_payment
452: fbt_payment_rec.fbt_payment_id := ln_fbt_payment_id;
453: fbt_payment_rec.legal_entity_id := pn_legal_entity_id;

Line 518: FROM dual;

514: -- ap_invoice_lines_interface
515: -- get invoice line id
516: SELECT ap_invoice_lines_interface_s.nextval
517: INTO ln_invoice_line_id
518: FROM dual;
519:
520: --added by eric ma for bug 7325833 on 18-Aug-2008,begin
521: -----------------------------------------------------------------------------------
522: OPEN get_fbt_account_ccid_cur;