APPS.IGIRX_IAC_PROJ dependencies on IGI_IAC_PROJECTIONS

Line 35: FROM igi_iac_projections

31: SELECT book_type_code,
32: start_period_counter,
33: end_period,
34: revaluation_period
35: FROM igi_iac_projections
36: WHERE projection_id = n_projection_id;
37:
38: -- Get the detail level projection data
39: CURSOR c_proj_data(n_proj_id igi_iac_projections.projection_id%TYPE)

Line 39: CURSOR c_proj_data(n_proj_id igi_iac_projections.projection_id%TYPE)

35: FROM igi_iac_projections
36: WHERE projection_id = n_projection_id;
37:
38: -- Get the detail level projection data
39: CURSOR c_proj_data(n_proj_id igi_iac_projections.projection_id%TYPE)
40: IS
41: SELECT dp.projection_id,
42: dp.period_counter proj_period_counter,
43: dp.category_id,

Line 404: DELETE FROM igi_iac_projections

400:
401: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End populating IAC Projections RXi interface table');
402:
403: -- 02-Oct-2003, Bug 3140574, delete from main projections tables
404: DELETE FROM igi_iac_projections
405: WHERE projection_id = p_projection_id;
406:
407: DELETE FROM igi_iac_proj_details
408: WHERE projection_id = p_projection_id;