DBA Data[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 1426: SELECT COUNT(*) from AHL_MR_RELATIONSHIPS

1422: l_origin_wo_id NUMBER;
1423: -- End changes for ER -- 6123671
1424:
1425: CURSOR get_num_descendents_csr(p_mr_id IN NUMBER) IS
1426: SELECT COUNT(*) from AHL_MR_RELATIONSHIPS
1427: WHERE MR_HEADER_ID = p_mr_id;
1428:
1429: l_temp_level NUMBER;
1430: l_dummy VARCHAR2(1);