DBA Data[Home] [Help]

APPS.MSD_HIERARCHIES_PKG dependencies on DUAL

Line 252: select 1 into h_mod from dual

248: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
249:
250: -- check if any hierarchy levels exist that were updated by !seed
251: begin
252: select 1 into h_mod from dual
253: where exists(select 1 from msd_hierarchy_levels
254: where hierarchy_id = to_number(x_HIERARCHY_id)
255: and nvl( plan_type,-1) = nvl( to_char(x_plan_type),-1)
256: and last_updated_by <> 1);

Line 344: FROM dual

340: f_luby,
341: f_ludate,
342: f_luby,
343: 0
344: FROM dual
345: WHERE
346: (x_custom_mode = 'FORCE')
347: OR
348: (