DBA Data[Home] [Help]

APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on DUAL

Line 1594: FROM dual;

1590: SELECT 'IPAC'||TO_CHAR(fv_ipac_batch_s.NEXTVAL),
1591: ap_interface_groups_s.NEXTVAL
1592: INTO p_batch_name,
1593: p_group_id
1594: FROM dual;
1595:
1596: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1597: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_batch_name = '||p_batch_name);
1598: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_group_id = '||p_group_id);

Line 1956: FROM dual

1952: g_user_id,
1953: SYSDATE,
1954: g_login_id,
1955: g_user_id
1956: FROM dual
1957: WHERE NOT EXISTS (SELECT invoice_id
1958: FROM fv_ipac_recurring_inv
1959: WHERE invoice_id = l_invoice_id
1960: AND batch_name = p_batch_name);

Line 3086: FROM DUAL;

3082: --* get the invoice header sequence number *--
3083: --****************************************************************************************--
3084: SELECT ap_invoices_interface_s.NEXTVAL
3085: INTO l_inv_hdrs_interface_rec.invoice_id
3086: FROM DUAL;
3087: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3088: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'invoice_id ='||l_inv_hdrs_interface_rec.invoice_id);
3089: END IF;
3090: EXCEPTION