APPS.GCS_ENTRY_PKG dependencies on DUAL

Line 633: FROM DUAL

629: -- we simply update this entry
630: BEGIN
631: SELECT 'Y'
632: INTO l_processed_entry_flag
633: FROM DUAL
634: WHERE EXISTS (SELECT run_detail_id
635: FROM gcs_cons_eng_run_dtls gcerd
636: WHERE gcerd.entry_id = p_entry_id);
637: EXCEPTION

Line 997: SELECT gcs_entry_headers_s.NEXTVAL INTO p_entry_id FROM DUAL;

993: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
994: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
995: END IF;
996: IF p_entry_id IS NULL THEN
997: SELECT gcs_entry_headers_s.NEXTVAL INTO p_entry_id FROM DUAL;
998: END IF;
999: get_entry_header(p_category_code => p_category_code,
1000: p_xlate_flag => p_xlate_flag,
1001: p_entry_id => p_entry_id,