APPS.GME_TRANSFORM_BATCH dependencies on SY_REAS_CDS_B

Line 389: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);

385:
386: PROCEDURE update_reason_id(p_migration_run_id NUMBER) IS
387: BEGIN
388: UPDATE gme_resource_txns t
389: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
390: gma_common_logging.gma_migration_central_log
391: (p_run_id => p_migration_run_id,
392: p_log_level => fnd_log.level_procedure,
393: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',

Line 399: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);

395: p_context => 'REASON_ID',
396: p_param1 => SQL%ROWCOUNT,
397: p_app_short_name => 'GMA');
398: UPDATE gme_resource_txns_mig t
399: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
400: gma_common_logging.gma_migration_central_log
401: (p_run_id => p_migration_run_id,
402: p_log_level => fnd_log.level_procedure,
403: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',