APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 916: FROM ahl_unit_effectivities_b eff,

912: MR.effective_from,
913: MR.effective_to,
914: eff.loop_chain_seq_num,
915: eff.accomplish_trigger_type relationship
916: FROM ahl_unit_effectivities_b eff,
917: (SELECT LOOKUP_CODE,
918: MEANING
919: FROM FND_LOOKUP_VALUES
920: WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'

Line 979: SELECT start_lc_ue_id INTO l_start_ue_id FROM ahl_unit_effectivities_b WHERE unit_effectivity_id = p_ue_id;

975:
976: --Loop through ahl_mr_relationships to find the relationship
977: IF p_calling_module IS NOT NULL AND p_calling_module = 'UMP'
978: THEN
979: SELECT start_lc_ue_id INTO l_start_ue_id FROM ahl_unit_effectivities_b WHERE unit_effectivity_id = p_ue_id;
980:
981: IF l_start_ue_id IS NULL THEN
982: l_start_ue_id := p_ue_id;
983: END IF;