APPS.XLE_HISTORY_PUB dependencies on XLE_REGISTRATIONS

Line 185: from xle_registrations

181: v_chk2:='0';
182:
183: begin
184: select effective_from into l_start_date
185: from xle_registrations
186: where registration_id = G_PRIMARY_KEY_ID
187: and rownum < 2;
188: exception
189: when NO_DATA_FOUND then

Line 423: from XLE_REGISTRATIONS where REGISTRATION_ID='||p_id

419: || G_VALUE_LIST(26).column_name ||','
420: || G_VALUE_LIST(27).column_name ||','
421: || G_VALUE_LIST(28).column_name ||','
422: || G_VALUE_LIST(29).column_name ||'
423: from XLE_REGISTRATIONS where REGISTRATION_ID='||p_id
424:
425: INTO G_VALUE_LIST(1).new_value
426: , G_VALUE_LIST(2).new_value
427: , G_VALUE_LIST(3).new_value