DBA Data[Home] [Help]

APPS.AHL_VWP_COST_PVT dependencies on AHL_VWP_ROLLUP_COSTS_V

Line 1936: FROM AHL_VWP_ROLLUP_COSTS_V

1932: -- Define Local Cursors
1933: CURSOR c_cost_csr(x_session_id IN NUMBER, x_id IN NUMBER, x_prg_id IN NUMBER) IS
1934: /*SELECT OBJECT_ID, SUM (ACTUAL_COST) ACTUAL_COST,
1935: SUM (ESTIMATED_COST) ESTIMATED_COST
1936: FROM AHL_VWP_ROLLUP_COSTS_V
1937: WHERE GROUP_ID = x_session_id
1938: AND OBJECT_ID = x_id
1939: AND PROGRAM_APPLICATION_ID = x_prg_id
1940: GROUP BY OBJECT_ID; */

Line 1943: FROM AHL_VWP_ROLLUP_COSTS_V

1939: AND PROGRAM_APPLICATION_ID = x_prg_id
1940: GROUP BY OBJECT_ID; */
1941:
1942: SELECT *
1943: FROM AHL_VWP_ROLLUP_COSTS_V
1944: WHERE GROUP_ID = x_session_id
1945: AND OBJECT_ID = x_id
1946: AND PROGRAM_APPLICATION_ID = x_prg_id;
1947: