APPS.PA_PROJECT_VERIFY_PKG dependencies on DUAL

Line 51: FROM sys.dual

47: --sunkalya:federal Bug#5511353
48: IF l_en_top_task_cust_flag <> 'Y' AND l_date_eff_funds_flag <> 'Y' THEN
49: SELECT NULL
50: INTO dummy
51: FROM sys.dual
52: WHERE exists (
53: SELECT NULL
54: FROM PA_PROJECT_CUSTOMERS
55: WHERE PROJECT_ID = x_project_id

Line 94: FROM sys.dual

90: x_err_msgname := NULL;
91: x_err_stage := 'Checking contact exists...';
92: SELECT NULL
93: INTO dummy
94: FROM sys.dual
95: WHERE exists (
96: SELECT NULL
97: FROM PA_PROJECT_CUSTOMERS CUST
98: WHERE CUST.PROJECT_ID = x_project_id

Line 149: FROM DUAL

145:
146: CURSOR C11
147: IS
148: SELECT NULL
149: FROM DUAL
150: WHERE EXISTS
151: (
152: SELECT 1
153: FROM PA_CLASS_CATEGORIES cc,

Line 176: FROM DUAL

172:
173: CURSOR C12
174: IS
175: SELECT NULL
176: FROM DUAL
177: WHERE EXISTS (SELECT 1
178: from PA_CLASS_CATEGORIES CC
179: WHERE CC.MANDATORY_FLAG = 'Y'
180: AND CC.OBJECT_TYPE = 'PA_PROJECTS'

Line 305: SELECT TRUNC(Sysdate) INTO proj_start_date FROM Dual;

301:
302: OPEN c1 ;
303: FETCH c1 INTO proj_start_date ;
304: IF c1%notfound then
305: SELECT TRUNC(Sysdate) INTO proj_start_date FROM Dual;
306: END IF;
307: CLOSE c1 ;
308:
309: /* Changed the following logic to use cursor and loop */

Line 440: FROM sys.dual

436: in Rel 11.0 - Ramesh - 01/13/1998
437: x_err_stage := 'Checking billing event exists...';
438: SELECT NULL
439: INTO dummy
440: FROM sys.dual
441: WHERE exists (
442: select NULL
443: from pa_events e
444: , pa_event_Types et