APPS.OZF_SD_BATCH_PVT dependencies on DUAL

Line 729: FROM dual;

725: l_last_run_date := l_last_run_date + l_freq;
726: ELSIF l_freq_unit = 'MONTHS' then
727: SELECT add_months(l_last_run_date, l_freq)
728: INTO l_last_run_date
729: FROM dual;
730: ELSIF l_freq_unit = 'YEAR' then
731: SELECT add_months(l_last_run_date, l_freq * 12)
732: INTO l_last_run_date
733: FROM dual;

Line 733: FROM dual;

729: FROM dual;
730: ELSIF l_freq_unit = 'YEAR' then
731: SELECT add_months(l_last_run_date, l_freq * 12)
732: INTO l_last_run_date
733: FROM dual;
734: END IF;
735:
736: IF OZF_DEBUG_LOW_ON THEN
737: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_last_run_date :' || to_char(l_last_run_date));

Line 877: FROM dual;

873: l_last_run_date := l_last_run_date + l_freq;
874: ELSIF l_freq_unit = 'MONTHS' then
875: SELECT add_months(l_last_run_date, l_freq)
876: INTO l_last_run_date
877: FROM dual;
878: ELSIF l_freq_unit = 'YEAR' then
879: SELECT add_months(l_last_run_date, l_freq * 12)
880: INTO l_last_run_date
881: FROM dual;

Line 881: FROM dual;

877: FROM dual;
878: ELSIF l_freq_unit = 'YEAR' then
879: SELECT add_months(l_last_run_date, l_freq * 12)
880: INTO l_last_run_date
881: FROM dual;
882: END IF;
883:
884: FND_FILE.PUT_LINE(FND_FILE.LOG,'SuppSite Loop: l_last_run_date post calculation : ' || l_last_run_date);
885:

Line 1485: SELECT ozf_sd_batch_headers_all_s.nextval INTO l_batch_id FROM dual;

1481: l_supplier_id := p_supplier_id;
1482: l_supplier_site_id := p_supplier_site_id;
1483: l_batch_new := p_batch_new;
1484:
1485: SELECT ozf_sd_batch_headers_all_s.nextval INTO l_batch_id FROM dual;
1486:
1487: l_org_id := p_org_id;
1488: p_batch_id := l_batch_id;
1489: l_batch_threshold := p_batch_threshold;