97:
98: BEGIN
99: SELECT 'Y'
100: INTO l_recur_entry_flag 101: FROM dual 102: WHERE EXISTS
103: (SELECT 1
104: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
105: GCS_ENTRY_HEADERS GHD
Line 241: FROM dual
237:
238: BEGIN
239: SELECT 'Y'
240: INTO l_recur_entry_flag 241: FROM dual 242: WHERE EXISTS
243: (SELECT 1
244: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
245: GCS_ENTRY_HEADERS GHD