APPS.PA_PROJECT_PVT dependencies on DUAL

Line 386: From dual;

382: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE, TRUNC(SYSDATE),
383: NULL,TRUNC(SYSDATE),
384: p_key_members(i).start_date)
385: Into v_start_date_active
386: From dual;
387: */ --commented and added following line. --Ansari
388:
389: -- v_start_date_active := PA_PROJECT_PARTIES_PUB.GET_KEY_MEMBER_START_DATE (p_project_id);
390:

Line 598: FROM DUAL

594: /* Start of code for Performance Bug # 3693217*/
595: CURSOR l_valid_category_csr1 (c_project_id NUMBER, c_class_category VARCHAR2)
596: IS
597: SELECT 'Y'
598: FROM DUAL
599: WHERE EXISTS
600: (
601: SELECT 'Y'
602: FROM PA_CLASS_CATEGORIES cc,

Line 622: FROM DUAL

618:
619: CURSOR l_valid_category_csr2 ( c_class_category VARCHAR2)
620: IS
621: SELECT 'Y'
622: FROM DUAL
623: WHERE EXISTS
624: (
625: SELECT 'Y'
626: FROM PA_CLASS_CATEGORIES cc

Line 2269: FROM DUAL;

2265: --get the unique task id from the Oracle Sequence
2266:
2267: SELECT pa_tasks_s.nextval
2268: INTO l_task_id
2269: FROM DUAL;
2270: /* dbms_output.put_line('Task ID:'||l_task_id); */
2271:
2272: --insert the intermediate result in the database
2273:

Line 10494: From dual;

10490: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE, TRUNC(SYSDATE),
10491: NULL,TRUNC(SYSDATE),
10492: p_org_roles(i).start_date)
10493: Into v_start_date_active
10494: From dual;
10495: */ --Commented and added the following line -- By Ansari
10496: v_start_date_active := null;
10497:
10498: Select project_role_id