APPS.AHL_RA_NR_PROFILE_PVT dependencies on AHL_UE_SIMULATIONS

Line 35: FROM ahl_ue_simulations

31:
32: CURSOR get_ue_item_instance_sim(c_ue_id NUMBER, c_instance_id NUMBER)
33: IS
34: SELECT fleet_header_id
35: FROM ahl_ue_simulations
36: WHERE simulation_ue_id = c_ue_id
37: AND csi_item_instance_id = c_instance_id ;
38:
39: CURSOR get_fleet_details(c_fleet_header_id NUMBER)

Line 131: -- Else derive fleet header id from ahl_ue_simulations

127: END IF;
128: CLOSE get_profile_ident_seqs;
129:
130: -- Get the primary plan flag, If it is primary derive fleet header id from ahl_unit_effectivities_b
131: -- Else derive fleet header id from ahl_ue_simulations
132:
133: IF(p_plan_id IS NOT NULL)
134: THEN
135: OPEN get_primary_plan_flag(p_plan_id);

Line 372: FROM ahl_ue_simulations

368:
369: CURSOR get_ue_item_instance_sim(c_ue_id NUMBER, c_instance_id NUMBER)
370: IS
371: SELECT fleet_header_id
372: FROM ahl_ue_simulations
373: WHERE simulation_ue_id = c_ue_id
374: AND csi_item_instance_id = c_instance_id ;
375:
376: CURSOR get_fleet_details(c_fleet_header_id NUMBER)

Line 467: -- Else derive fleet header id from ahl_ue_simulations

463: END IF;
464: CLOSE get_profile_ident_seqs;
465:
466: -- Get the primary plan flag, If it is primary derive fleet header id from ahl_unit_effectivities_b
467: -- Else derive fleet header id from ahl_ue_simulations
468:
469: IF(p_plan_id IS NOT NULL)
470: THEN
471: OPEN get_primary_plan_flag(p_plan_id);