APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_APPLICABLE_MR_RELNS

Line 2835: FROM ahl_applicable_mr_relns

2831: -- Check if MR is a group MR.
2832: CURSOR group_check_csr (p_item_instance_id IN NUMBER,
2833: p_mr_header_id IN NUMBER) IS
2834: SELECT 'x'
2835: FROM ahl_applicable_mr_relns
2836: WHERE orig_csi_item_instance_id = p_item_instance_id AND
2837: orig_mr_header_id = p_mr_header_id;
2838:
2839: -- Get next due date of preceding MR from temporary table.

Line 6094: FROM ahl_applicable_mr_relns

6090:
6091: SELECT mr_header_id, csi_item_instance_id,
6092: related_mr_header_id,
6093: related_csi_item_instance_id
6094: FROM ahl_applicable_mr_relns
6095: WHERE level = p_level
6096: START WITH mr_header_id = p_mr_header_id AND
6097: csi_item_instance_id = p_item_instance_id AND
6098: orig_mr_header_id = p_mr_header_id AND

Line 6114: FROM ahl_applicable_mr_relns

6110: p_mr_header_id IN NUMBER) IS
6111:
6112: SELECT mr_header_id, csi_item_instance_id, related_mr_header_id,
6113: related_csi_item_instance_id
6114: FROM ahl_applicable_mr_relns
6115: START WITH mr_header_id = p_mr_header_id AND
6116: csi_item_instance_id = p_item_instance_id AND
6117: orig_mr_header_id = p_mr_header_id AND
6118: orig_csi_item_instance_id = p_item_instance_id AND

Line 6202: -- with the one in ahl_applicable_mr_relns.

6198: l_grp_match := FALSE; /* set default to be "no group" available to match against in ahl_unit_effectitivities. */
6199:
6200: IF (p_old_UE_forecast_sequence <> -1) THEN
6201: -- match the group tree under unit_effectivity_id in unit_effectivity_tbl(l_old_UE_forecast_sequence)
6202: -- with the one in ahl_applicable_mr_relns.
6203:
6204: l_level := 0; /* tree level */
6205: l_unit_effectivity_id := p_unit_effectivity_tbl(p_old_UE_forecast_sequence).unit_effectivity_id;
6206:

Line 8615: FROM ahl_applicable_mr_relns

8611: SELECT related_mr_header_id,
8612: related_csi_item_instance_id,
8613: csi_item_instance_id parent_csi_item_instance_id,
8614: mr_header_id parent_mr_header_id
8615: FROM ahl_applicable_mr_relns
8616: START WITH mr_header_id = p_mr_header_id AND
8617: csi_item_instance_id = p_item_instance_id AND
8618: orig_mr_header_id = p_mr_header_id AND
8619: orig_csi_item_instance_id = p_item_instance_id AND

Line 9106: FROM ahl_applicable_mr_relns

9102: SELECT related_mr_header_id,
9103: related_csi_item_instance_id,
9104: csi_item_instance_id parent_csi_item_instance_id,
9105: mr_header_id parent_mr_header_id
9106: FROM ahl_applicable_mr_relns
9107: START WITH mr_header_id = p_mr_header_id AND
9108: csi_item_instance_id = p_item_instance_id AND
9109: orig_mr_header_id = p_mr_header_id AND
9110: orig_csi_item_instance_id = p_item_instance_id AND

Line 9336: FROM ahl_applicable_mr_relns

9332:
9333: SELECT mr_header_id, csi_item_instance_id,
9334: related_mr_header_id,
9335: related_csi_item_instance_id, level
9336: FROM ahl_applicable_mr_relns
9337: START WITH mr_header_id = p_mr_header_id AND
9338: csi_item_instance_id = p_item_instance_id AND
9339: orig_mr_header_id = p_mr_header_id AND
9340: orig_csi_item_instance_id = p_item_instance_id AND