APPS.PA_DELIVERABLE_PVT dependencies on DUAL

Line 3206: FROM DUAL

3202: -- Bug 3651781 While deleting association between a deliverable based task and a deliverable ,we have to
3203: -- Look for 'PUBLISHED' progress records ,NOT mere existence of progress records
3204: CURSOR C(c_project_id IN NUMBER) IS
3205: SELECT 'Y'
3206: FROM DUAL
3207: WHERE EXISTS (SELECT 'Y'
3208: FROM pa_proj_element_versions pev
3209: ,pa_object_relationships obj1
3210: ,pa_object_relationships obj2

Line 3238: FROM DUAL

3234: -- if below cursor returns Y, workplan task to deliverable association deletion is not allowed, error message is populated
3235:
3236: CURSOR C(c_project_id IN NUMBER) IS
3237: SELECT 'Y'
3238: FROM DUAL
3239: WHERE EXISTS (SELECT 'Y'
3240: FROM pa_proj_elements ppe
3241: ,pa_object_relationships obj1
3242: ,pa_task_types ptt

Line 3436: from dual

3432: But with little modifications - bug 3906015*/
3433: /*
3434: CURSOR C (c_project_id IN NUMBER) IS
3435: SELECT 'Y'
3436: from dual
3437: WHERE EXISTS(
3438: SELECT 'Y'
3439: FROM PA_PROJ_ELEMENT_VERSIONS pev1,
3440: PA_OBJECT_RELATIONSHIPS obj1,

Line 3471: from dual

3467: -- if below cursor returns Y, workplan task to deliverable association deletion is not allowed, error message is populated
3468:
3469: CURSOR C (c_project_id IN NUMBER) IS
3470: SELECT 'Y'
3471: from dual
3472: WHERE EXISTS(
3473: SELECT 'Y'
3474: FROM pa_proj_elements ppe
3475: ,pa_object_relationships obj1

Line 3940: FROM dual ;

3936: SELECT pa_tasks_s.nextval
3937: ,pa_proj_element_versions_s.nextval
3938: INTO l_parent_structure_id
3939: ,l_parent_structure_version_id
3940: FROM dual ;
3941:
3942:
3943: -- If p_calling_context is COPY_PROJECT then first
3944: -- populate the structure level record .