APPS.INV_OPM_REASON_CODE_MIGRATION dependencies on SY_REAS_CDS_B

Line 43: FROM sy_reas_cds_b b, sy_reas_cds_tl tl,

39: b.creation_date,
40: b.created_by,
41: b.last_updated_by,
42: b.last_update_login
43: FROM sy_reas_cds_b b, sy_reas_cds_tl tl,
44: fnd_languages fl
45: WHERE tl.language = fl.language_code
46: AND fl.installed_flag = 'B'
47: AND b.reason_code = tl.reason_code

Line 63: update sy_reas_cds_b a set a.reason_id =

59: , p_table_name => 'SY_REAS_CDS'
60: , p_context => 'REASON_CODES');
61:
62: -- bug16067107
63: update sy_reas_cds_b a set a.reason_id =
64: (select reason_id from mtl_transaction_reasons b where b.reason_name = a.reason_code);
65:
66: FOR l_rec IN opm_reas_cds_cur LOOP
67:

Line 95: UPDATE sy_reas_cds_b

91: , l_rec.last_update_login);
92:
93: /* set the reason_id column in sy_reas_cds with this new reason_id */
94:
95: UPDATE sy_reas_cds_b
96: SET reason_id = l_reason_id
97: WHERE reason_code = l_rec.reason_code;
98:
99: EXCEPTION