DBA Data[Home] [Help]

APPS.FUN_NET_ARAP_PKG dependencies on DUAL

Line 1102: FROM dual;

1098: WHERE batch_id = g_batch_id;
1099: IF l_checkrun_id is NULL THEN
1100: SELECT ap_inv_selection_criteria_s.nextval
1101: INTO l_checkrun_id
1102: FROM dual;
1103: fun_net_util.Log_String(g_state_level,l_path,'l_checkrun_id :'||l_checkrun_id);
1104: -- Update Netting Batch with the Checkrun id
1105: UPDATE FUN_NET_BATCHES_ALL
1106: SET checkrun_id = l_checkrun_id

Line 2040: FROM DUAL;

2036: l_path := g_path||'insert_batch_record';
2037: /* Check for mandatory parameters and all values that are going to be inserted */
2038: SELECT fun_net_batches_s.NEXTVAL
2039: INTO g_batch_id
2040: FROM DUAL;
2041: INSERT INTO FUN_NET_BATCHES_ALL
2042: (batch_id,
2043: object_version_number,
2044: agreement_id,

Line 3343: FROM DUAL;

3339: ap_check_rec.vendor_site_id := vendor_site_list(i);
3340: /* Get Check Number from Sequence */
3341: SELECT fun.fun_net_ap_checks_s.nextval
3342: INTO ap_check_rec.check_number
3343: FROM DUAL;
3344: ap_check_rec.CHECK_DATE := g_batch_details.settlement_date;
3345: l_gl_date := nvl(g_batch_details.gl_date, g_batch_details.settlement_date); /* 7639863 */
3346: IF currency_list(i) = g_func_currency THEN
3347: ap_check_rec.exchange_rate := 1.0;