APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 2710: FROM AHL_MR_RELATIONSHIPS mrr, ahl_applicable_mrs parent_appl

2706: UPDATE AHL_APPLICABLE_MRS appl
2707: SET processing_order = 2,
2708: terminate_trigger_check = 'Y'
2709: WHERE EXISTS (SELECT 'x'
2710: FROM AHL_MR_RELATIONSHIPS mrr, ahl_applicable_mrs parent_appl
2711: WHERE mrr.related_mr_header_id = appl.mr_header_id
2712: AND mrr.mr_header_id = parent_appl.mr_header_id -- parent row exists
2713: AND parent_appl.csi_item_instance_id = appl.csi_item_instance_id
2714: AND mrr.relationship_code = 'TERMINATES');

Line 7789: FROM ahl_mr_relationships amr, ahl_applicable_mrs apmr, ahl_mr_headers_b mr

7785: mr.title,
7786: mr.effective_from,
7787: mr.effective_to,
7788: apmr.terminate_trigger_check
7789: FROM ahl_mr_relationships amr, ahl_applicable_mrs apmr, ahl_mr_headers_b mr
7790: WHERE amr.mr_header_id = p_curr_mr_header_id
7791: AND amr.related_mr_header_id = apmr.mr_header_id
7792: AND amr.relationship_code = 'INITIATES'
7793: AND amr.related_mr_header_id = mr.mr_header_id

Line 7797: FROM ahl_mr_relationships amr1, ahl_applicable_mrs apmr1

7793: AND amr.related_mr_header_id = mr.mr_header_id
7794: AND apmr.csi_item_instance_id = p_item_instance_id
7795: -- select only those 'follow after' MRs if all parent MRs are processed.
7796: AND NOT EXISTS (SELECT 'x'
7797: FROM ahl_mr_relationships amr1, ahl_applicable_mrs apmr1
7798: WHERE amr1.related_mr_header_id = amr.related_mr_header_id
7799: AND amr1.mr_header_id = apmr1.mr_header_id
7800: AND amr1.relationship_code NOT IN ('TERMINATES')
7801: AND (nvl(apmr1.process_status_flag,'N') = 'N'

Line 7840: from ahl_mr_relationships amr, ahl_applicable_mrs apmr

7836: CURSOR get_preceding_mrs_csr (p_item_instance_id IN number,
7837: p_follow_mr_header_id IN number) IS
7838:
7839: select amr.mr_header_id, apmr.accomplished_ue_id, apmr.process_status_flag
7840: from ahl_mr_relationships amr, ahl_applicable_mrs apmr
7841: where amr.mr_header_id = apmr.mr_header_id
7842: and amr.relationship_code = 'INITIATES'
7843: and amr.related_mr_header_id = p_follow_mr_header_id
7844: and apmr.csi_item_instance_id = p_item_instance_id;

Line 14774: FROM ahl_mr_relationships amr, ahl_applicable_mrs apmr, ahl_mr_headers_b mr

14770: mr.effective_to,
14771: apmr.process_status_flag,
14772: apmr.accomplished_ue_id,
14773: apmr.terminate_trigger_check
14774: FROM ahl_mr_relationships amr, ahl_applicable_mrs apmr, ahl_mr_headers_b mr
14775: WHERE amr.related_mr_header_id = p_mr_header_id
14776: AND amr.mr_header_id = apmr.mr_header_id
14777: AND amr.relationship_code = 'TERMINATES'
14778: AND amr.mr_header_id = mr.mr_header_id