DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on DUAL

Line 2854: FROM DUAL

2850: IF p_task_elem_version_id_tbl(i) <> 0 THEN -- For Task level record
2851: BEGIN
2852: SELECT 'Y'
2853: INTO l_bl_already_exists
2854: FROM DUAL
2855: WHERE EXISTS ( SELECT 1
2856: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV
2857: WHERE PRA.PROJECT_ID = p_project_id
2858: AND PRA.BUDGET_VERSION_ID = p_budget_version_id

Line 2893: FROM DUAL

2889: -- is not references anywhere in the WHERE clause.
2890:
2891: SELECT 'Y'
2892: INTO l_bl_already_exists
2893: FROM DUAL
2894: WHERE EXISTS ( SELECT 1
2895: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA
2896: --,PA_PROJ_ELEMENT_VERSIONS PEV /* Bug 4884718; SQL ID 14903213 */
2897: WHERE PRA.PROJECT_ID = p_project_id