APPS.GMD_QC_MIGRATE_TO_1151J dependencies on QC_HRES_MST_BAK

Line 1044: FROM qc_hres_mst_bak

1040: attribute28,
1041: attribute29,
1042: attribute30,
1043: attribute_category
1044: FROM qc_hres_mst_bak
1045: WHERE decode(migration_status,NULL,'NM') <> 'MO';
1046:
1047: INSERT INTO gmd_hold_reasons_tl
1048: (

Line 1069: FROM qc_hres_mst_bak

1065: created_by,
1066: last_update_date,
1067: last_updated_by,
1068: last_update_login
1069: FROM qc_hres_mst_bak
1070: WHERE decode(migration_status,NULL,'NM') <> 'MO';
1071:
1072: /* Updated record status to migrated */
1073: UPDATE qc_hres_mst_bak

Line 1073: UPDATE qc_hres_mst_bak

1069: FROM qc_hres_mst_bak
1070: WHERE decode(migration_status,NULL,'NM') <> 'MO';
1071:
1072: /* Updated record status to migrated */
1073: UPDATE qc_hres_mst_bak
1074: SET migration_status = 'MO';
1075:
1076: l_rec_count := SQL%ROWCOUNT;
1077:

Line 1080: p_table_name => 'QC_HRES_MST_BAK',

1076: l_rec_count := SQL%ROWCOUNT;
1077:
1078: GMA_MIGRATION.gma_insert_message (
1079: p_run_id => p_migration_id,
1080: p_table_name => 'QC_HRES_MST_BAK',
1081: p_DB_ERROR => '',
1082: p_param1 => '',
1083: p_param2 => l_rec_count,
1084: p_param3 => '',

Line 1101: p_table_name => 'QC_HRES_MST_BAK',

1097: WHEN OTHERS THEN
1098: x_return_status := 'U';
1099: GMA_MIGRATION.gma_insert_message (
1100: p_run_id => p_migration_id,
1101: p_table_name => 'QC_HRES_MST_BAK',
1102: p_DB_ERROR => sqlerrm,
1103: p_param1 => '',
1104: p_param2 => '',
1105: p_param3 => '',

Line 1116: p_table_name => 'QC_HRES_MST_BAK',

1112: p_base_message => 'Failed to migrate hold reasons due to '||sqlerrm);
1113:
1114: GMA_MIGRATION.gma_insert_message (
1115: p_run_id => p_migration_id,
1116: p_table_name => 'QC_HRES_MST_BAK',
1117: p_DB_ERROR => '',
1118: p_param1 => '',
1119: p_param2 => '',
1120: p_param3 => '',