APPS.AHL_RM_ASO_RESOURCE_PVT dependencies on BOM_RESOURCES

Line 878: FROM BOM_RESOURCES

874:
875: CURSOR get_bom_rec ( c_bom_resource_id NUMBER)
876: IS
877: SELECT resource_type, disable_date
878: FROM BOM_RESOURCES
879: WHERE resource_id = c_bom_resource_id;
880:
881: l_get_bom_rec get_bom_rec%ROWTYPE;
882: l_res_type NUMBER;

Line 1125: --whether one BOM resource per organization or multiple BOM resources per organization

1121: CLOSE get_bom_res_num;
1122:
1123: --pekambar ER # 9014609 -- Start
1124: --The Following validation has been changed based on input flag choosen by user
1125: --whether one BOM resource per organization or multiple BOM resources per organization
1126:
1127: /*OPEN get_bom_res_org (p_aso_resource_id);
1128: FETCH get_bom_res_org INTO l_dummy_num;
1129: IF get_bom_res_org%FOUND THEN