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 86: FROM sys.dual

82: x_err_msgname := NULL;
83: x_err_stage := 'Checking contact exists...';
84: SELECT NULL
85: INTO dummy
86: FROM sys.dual
87: WHERE exists (
88: SELECT NULL
89: FROM PA_PROJECT_CUSTOMERS CUST
90: WHERE CUST.PROJECT_ID = x_project_id

Line 141: FROM DUAL

137:
138: CURSOR C11
139: IS
140: SELECT NULL
141: FROM DUAL
142: WHERE EXISTS
143: (
144: SELECT 1
145: FROM PA_CLASS_CATEGORIES cc,

Line 168: FROM DUAL

164:
165: CURSOR C12
166: IS
167: SELECT NULL
168: FROM DUAL
169: WHERE EXISTS (SELECT 1
170: from PA_CLASS_CATEGORIES CC
171: WHERE CC.MANDATORY_FLAG = 'Y'
172: AND CC.OBJECT_TYPE = 'PA_PROJECTS'

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

293:
294: OPEN c1 ;
295: FETCH c1 INTO proj_start_date ;
296: IF c1%notfound then
297: SELECT TRUNC(Sysdate) INTO proj_start_date FROM Dual;
298: END IF;
299: CLOSE c1 ;
300:
301: /* Changed the following logic to use cursor and loop */

Line 432: FROM sys.dual

428: in Rel 11.0 - Ramesh - 01/13/1998
429: x_err_stage := 'Checking billing event exists...';
430: SELECT NULL
431: INTO dummy
432: FROM sys.dual
433: WHERE exists (
434: select NULL
435: from pa_events e
436: , pa_event_Types et