DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on DUAL

Line 2834: FROM DUAL

2830: IF p_task_elem_version_id_tbl(i) <> 0 THEN -- For Task level record
2831: BEGIN
2832: SELECT 'Y'
2833: INTO l_bl_already_exists
2834: FROM DUAL
2835: WHERE EXISTS ( SELECT 1
2836: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV
2837: WHERE PRA.PROJECT_ID = p_project_id
2838: AND PRA.BUDGET_VERSION_ID = p_budget_version_id

Line 2871: FROM DUAL

2867: -- is not references anywhere in the WHERE clause.
2868:
2869: SELECT 'Y'
2870: INTO l_bl_already_exists
2871: FROM DUAL
2872: WHERE EXISTS ( SELECT 1
2873: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA
2874: --,PA_PROJ_ELEMENT_VERSIONS PEV /* Bug 4884718; SQL ID 14903213 */
2875: WHERE PRA.PROJECT_ID = p_project_id