APPS.IEC_AORECDNU_PUB dependencies on IEC_G_RETURN_ENTRIES

Line 97: select returns_id,itm_cc_tz_id into l_returns_id, l_itm_cc_tz_id from iec_g_return_entries

93: ---------------------------------------------------------------------
94:
95: -- DO ACTUAL WORK HERE
96: BEGIN
97: select returns_id,itm_cc_tz_id into l_returns_id, l_itm_cc_tz_id from iec_g_return_entries
98: where list_entry_id = p_list_entry_id and list_header_id = p_list_header_id;
99:
100: update iec_g_return_entries set do_not_use_flag = 'Y',
101: do_not_use_reason = l_dnu_reason_code,

Line 100: update iec_g_return_entries set do_not_use_flag = 'Y',

96: BEGIN
97: select returns_id,itm_cc_tz_id into l_returns_id, l_itm_cc_tz_id from iec_g_return_entries
98: where list_entry_id = p_list_entry_id and list_header_id = p_list_header_id;
99:
100: update iec_g_return_entries set do_not_use_flag = 'Y',
101: do_not_use_reason = l_dnu_reason_code,
102: last_updated_by = p_user_id,
103: last_update_date = sysdate
104: where returns_id = l_returns_id;