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 2438: FROM DUAL;

2434: --get the unique task id from the Oracle Sequence
2435:
2436: SELECT pa_tasks_s.nextval
2437: INTO l_task_id
2438: FROM DUAL;
2439: /* dbms_output.put_line('Task ID:'||l_task_id); */
2440:
2441: --insert the intermediate result in the database
2442:

Line 10838: From dual;

10834: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE, TRUNC(SYSDATE),
10835: NULL,TRUNC(SYSDATE),
10836: p_org_roles(i).start_date)
10837: Into v_start_date_active
10838: From dual;
10839: */ --Commented and added the following line -- By Ansari
10840: v_start_date_active := null;
10841:
10842: --Bug#10124493 - project_role_type should be taken from pa_project_role_types_vl view