[Home] [Help]
770: CURSOR addtl_costs_cur( x_project_id NUMBER,
771: x_capital_event_id NUMBER,
772: x_request_id NUMBER) IS
773: SELECT 'Additional Costs Added'
774: FROM SYS.DUAL
775: WHERE EXISTS
776: (SELECT 'X'
777: FROM pa_expenditure_items_all
778: WHERE project_id = x_project_id
785: CURSOR addtl_assets_cur( x_project_id NUMBER,
786: x_capital_event_id NUMBER,
787: x_request_id NUMBER) IS
788: SELECT 'Additional Assets Added'
789: FROM SYS.DUAL
790: WHERE EXISTS
791: (SELECT 'X'
792: FROM pa_project_assets_all
793: WHERE project_id = x_project_id
977: /* Added below for bug 3961059 : Use of Exists clause */
978:
979: SELECT COUNT(*)
980: INTO v_ei_count
981: From Dual Where Exists
982: (Select 1
983: FROM pa_expenditure_items_all ei,
984: pa_tasks t
985: WHERE ei.project_id = p_project_id
1290: /* Added below for bug 3961059 : Use of Exists clause */
1291:
1292: SELECT COUNT(*)
1293: INTO v_ei_count
1294: From Dual Where Exists
1295: (Select 1
1296: FROM pa_expenditure_items_all
1297: WHERE capital_event_id = capital_event_rec.capital_event_id
1298: AND project_id = p_project_id
1318: /* Added Below for bug 3961059 : Use of Exists clause */
1319:
1320: SELECT COUNT(*)
1321: INTO v_ei_count
1322: From Dual Where Exists
1323: ( Select 1
1324: FROM pa_expenditure_items_all peia,
1325: pa_tasks t
1326: WHERE peia.task_id = t.task_id
1740: /* Added below for bug 3961059 :Use of Exists clause */
1741:
1742: SELECT COUNT(*)
1743: INTO v_asset_count
1744: From Dual Where Exists
1745: (Select 1
1746: FROM pa_project_assets_all pa,
1747: pa_project_asset_assignments paa
1748: WHERE pa.project_asset_id = paa.project_asset_id