APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 55: FROM ahl_mr_relationships rel,

51: IS
52: SELECT rel.mr_header_id,
53: rel.related_mr_header_id,
54: relationship_code
55: FROM ahl_mr_relationships rel,
56: ahl_mr_headers_b MR
57: WHERE (rel.mr_header_id = MR.mr_header_id
58: OR rel.related_mr_header_id = MR.mr_header_id)
59: AND (rel.mr_header_id = p_mr_header_id_csr

Line 976: --Loop through ahl_mr_relationships to find the relationship

972: IF FND_API.to_boolean(p_init_msg_list) THEN
973: FND_MSG_PUB.initialize;
974: END IF;
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: