APPS.AHL_RA_NR_PROFILE_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 28: FROM ahl_unit_effectivities_b

24:
25: CURSOR get_ue_item_instance(c_ue_id NUMBER, c_instance_id NUMBER)
26: IS
27: SELECT fleet_header_id
28: FROM ahl_unit_effectivities_b
29: WHERE unit_effectivity_id = c_ue_id
30: AND csi_item_instance_id = c_instance_id ;
31:
32: CURSOR get_ue_item_instance_sim(c_ue_id NUMBER, c_instance_id NUMBER)

Line 130: -- Get the primary plan flag, If it is primary derive fleet header id from ahl_unit_effectivities_b

126: GOTO end_of_mat_procedure;
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

Line 365: FROM ahl_unit_effectivities_b

361: IS
362: CURSOR get_ue_item_instance(c_ue_id NUMBER,c_instance_id NUMBER)
363: IS
364: SELECT FLEET_HEADER_ID
365: FROM ahl_unit_effectivities_b
366: WHERE unit_effectivity_id = c_ue_id
367: AND csi_item_instance_id = c_instance_id;
368:
369: CURSOR get_ue_item_instance_sim(c_ue_id NUMBER, c_instance_id NUMBER)

Line 466: -- Get the primary plan flag, If it is primary derive fleet header id from ahl_unit_effectivities_b

462: GOTO end_of_res_procedure;
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