APPS.GME_TRANSFORM_BATCH dependencies on SY_ORGN_MST

Line 83: FROM sy_orgn_mst sy

79: PROCEDURE create_gme_parameters(p_migration_run_id IN NUMBER,
80: x_exception_count OUT NOCOPY NUMBER) IS
81: CURSOR get_plant_and_labs IS
82: SELECT sy.organization_id, sy.orgn_code plant_code
83: FROM sy_orgn_mst sy
84: WHERE NOT EXISTS (SELECT 1
85: FROM gme_parameters
86: WHERE organization_id = sy.organization_id)
87: AND sy.organization_id IS NOT NULL;

Line 226: FROM sy_orgn_mst org

222: x_exception_count OUT NOCOPY NUMBER) IS
223: BEGIN
224: UPDATE gme_batch_header h
225: SET laboratory_ind = (SELECT DECODE (org.plant_ind, 1, 0, 2, 1)
226: FROM sy_orgn_mst org
227: WHERE org.orgn_code = h.plant_code),
228: migrated_batch_ind = 'Y'
229: WHERE laboratory_ind IS NULL;
230: gma_common_logging.gma_migration_central_log