DBA Data[Home] [Help]

APPS.AHL_VWP_COST_PVT dependencies on AHL_VWP_ROLLUP_COSTS_V

Line 1933: FROM AHL_VWP_ROLLUP_COSTS_V

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

Line 1940: FROM AHL_VWP_ROLLUP_COSTS_V

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