APPS.AHL_UMP_SR_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 1474: SELECT COUNT(*) from AHL_MR_RELATIONSHIPS

1470: l_origin_wo_id NUMBER;
1471: -- End changes for ER -- 6123671
1472:
1473: CURSOR get_num_descendents_csr(p_mr_id IN NUMBER) IS
1474: SELECT COUNT(*) from AHL_MR_RELATIONSHIPS
1475: WHERE MR_HEADER_ID = p_mr_id;
1476:
1477: -- bachandr Bug # 13916897 - start
1478: CURSOR c_get_sr_fleet(p_sr_ue_id IN NUMBER) IS