APPS.GME_TRANSFORM_BATCH dependencies on SY_REAS_CDS_B

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

487:
488: PROCEDURE update_reason_id(p_migration_run_id NUMBER) IS
489: BEGIN
490: UPDATE gme_resource_txns t
491: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
492: gma_common_logging.gma_migration_central_log
493: (p_run_id => p_migration_run_id,
494: p_log_level => fnd_log.level_procedure,
495: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',

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

497: p_context => 'REASON_ID',
498: p_param1 => SQL%ROWCOUNT,
499: p_app_short_name => 'GMA');
500: UPDATE gme_resource_txns_mig t
501: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
502: gma_common_logging.gma_migration_central_log
503: (p_run_id => p_migration_run_id,
504: p_log_level => fnd_log.level_procedure,
505: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',