APPS.GMP_RSRC_AVL_PKG dependencies on DUAL

Line 185: FROM DUAL ;

181: END IF;
182: --
183: SELECT to_char(p_to_date,'HH24:MI:SS')
184: INTO temp_date
185: FROM DUAL ;
186: --
187: /* B2992029 - Fix for Gantt Chart query for Resource Availability */
188: IF temp_date = '00:00:00' THEN
189: /* 21-NOV-2003 B3267633 - RESOURCE AVAILABILITY SHOWING AS ZERO IN OPM

Line 209: /* If Pl/SQL Tbl cal_rec has any residual rows,

205: --
206: CLOSE qty_c3;
207:
208: stmt_no := 10;
209: /* If Pl/SQL Tbl cal_rec has any residual rows,
210: we Need to clean before populating the
211: New Table */
212:
213: if cal_rec.COUNT > 0