APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on MTL_MATERIAL_STATUSES

Line 1142: from mtl_material_statuses

1138: /*
1139: --to get condition_id if condition meaning is provided
1140: CURSOR ahl_condition_csr ( p_condition in varchar2) is
1141: select status_id
1142: from mtl_material_statuses
1143: where status_code = p_condition;
1144: */
1145:
1146: --to get reason id if reason name is provided

Line 4926: FROM mtl_material_statuses

4922: -- validate condition.
4923: BEGIN
4924: SELECT 'x'
4925: INTO l_junk
4926: FROM mtl_material_statuses
4927: WHERE status_id = p_instance_condition_id
4928: AND enabled_flag = 1;
4929:
4930: EXCEPTION