APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_APPLICABLE_MR_RELNS

Line 3532: FROM ahl_applicable_mr_relns

3528: -- Check if MR is a group MR.
3529: CURSOR group_check_csr (p_item_instance_id IN NUMBER,
3530: p_mr_header_id IN NUMBER) IS
3531: SELECT 'x'
3532: FROM ahl_applicable_mr_relns
3533: WHERE orig_csi_item_instance_id = p_item_instance_id AND
3534: orig_mr_header_id = p_mr_header_id;
3535:
3536: -- Get next due date of preceding MR from temporary table.

Line 7380: FROM ahl_applicable_mr_relns

7376:
7377: SELECT mr_header_id, csi_item_instance_id,
7378: related_mr_header_id,
7379: related_csi_item_instance_id
7380: FROM ahl_applicable_mr_relns
7381: WHERE level = p_level
7382: START WITH mr_header_id = p_mr_header_id AND
7383: csi_item_instance_id = p_item_instance_id AND
7384: orig_mr_header_id = p_mr_header_id AND

Line 7400: FROM ahl_applicable_mr_relns

7396: p_mr_header_id IN NUMBER) IS
7397:
7398: SELECT mr_header_id, csi_item_instance_id, related_mr_header_id,
7399: related_csi_item_instance_id
7400: FROM ahl_applicable_mr_relns
7401: START WITH mr_header_id = p_mr_header_id AND
7402: csi_item_instance_id = p_item_instance_id AND
7403: orig_mr_header_id = p_mr_header_id AND
7404: orig_csi_item_instance_id = p_item_instance_id AND

Line 7488: -- with the one in ahl_applicable_mr_relns.

7484: l_grp_match := FALSE; /* set default to be "no group" available to match against in ahl_unit_effectitivities. */
7485:
7486: IF (p_old_UE_forecast_sequence <> -1) THEN
7487: -- match the group tree under unit_effectivity_id in unit_effectivity_tbl(l_old_UE_forecast_sequence)
7488: -- with the one in ahl_applicable_mr_relns.
7489:
7490: l_level := 0; /* tree level */
7491: l_unit_effectivity_id := p_unit_effectivity_tbl(p_old_UE_forecast_sequence).unit_effectivity_id;
7492:

Line 10104: FROM ahl_applicable_mr_relns

10100: SELECT related_mr_header_id,
10101: related_csi_item_instance_id,
10102: csi_item_instance_id parent_csi_item_instance_id,
10103: mr_header_id parent_mr_header_id
10104: FROM ahl_applicable_mr_relns
10105: START WITH mr_header_id = p_mr_header_id AND
10106: csi_item_instance_id = p_item_instance_id AND
10107: orig_mr_header_id = p_mr_header_id AND
10108: orig_csi_item_instance_id = p_item_instance_id AND

Line 10616: FROM ahl_applicable_mr_relns

10612: SELECT related_mr_header_id,
10613: related_csi_item_instance_id,
10614: csi_item_instance_id parent_csi_item_instance_id,
10615: mr_header_id parent_mr_header_id
10616: FROM ahl_applicable_mr_relns
10617: START WITH mr_header_id = p_mr_header_id AND
10618: csi_item_instance_id = p_item_instance_id AND
10619: orig_mr_header_id = p_mr_header_id AND
10620: orig_csi_item_instance_id = p_item_instance_id AND

Line 10867: FROM ahl_applicable_mr_relns

10863:
10864: SELECT mr_header_id, csi_item_instance_id,
10865: related_mr_header_id,
10866: related_csi_item_instance_id, level
10867: FROM ahl_applicable_mr_relns
10868: START WITH mr_header_id = p_mr_header_id AND
10869: csi_item_instance_id = p_item_instance_id AND
10870: orig_mr_header_id = p_mr_header_id AND
10871: orig_csi_item_instance_id = p_item_instance_id AND