APPS.GL_PERIOD_STATUS_SYNC_PUB dependencies on DUAL

Line 129: FROM DUAL

125: --Cursor to fetch the Ledger Short Name
126: CURSOR c_get_short_name
127: IS
128: SELECT 'Y'
129: FROM DUAL
130: WHERE EXISTS (SELECT short_name
131: FROM gl_ledgers
132: WHERE short_name = p_ledger_short_name);
133:

Line 142: FROM DUAL

138: c_start_date IN DATE
139: )
140: IS
141: SELECT 'Y'
142: FROM DUAL
143: WHERE EXISTS (
144: SELECT 1
145: FROM gl_period_statuses gps, gl_ledgers gl
146: WHERE gl.ledger_id = gps.ledger_id

Line 159: FROM DUAL

155: c_end_date IN DATE
156: )
157: IS
158: SELECT 'Y'
159: FROM DUAL
160: WHERE EXISTS (
161: SELECT 1
162: FROM gl_period_statuses gps, gl_ledgers gl
163: WHERE gl.ledger_id = gps.ledger_id