APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_MR_EFFECTIVITIES_APP_V

Line 10195: FROM ahl_mr_effectivities_app_v

10191: --get all the MR effectivity definitions for a given MR
10192: CURSOR get_mr_effect(c_mr_header_id NUMBER)
10193: IS
10194: SELECT mr_header_id, mr_effectivity_id, inventory_item_id
10195: FROM ahl_mr_effectivities_app_v
10196: WHERE mr_header_id = c_mr_header_id;
10197:
10198: -- get master org id.
10199: CURSOR get_master_org_id_csr (c_inventory_item_id IN NUMBER)