APPS.HXC_LAYOUTS_UPLOAD_PKG dependencies on DUAL

Line 179: FROM dual

175: CURSOR C_DISPLAY_NAME(p_layout_id IN NUMBER)
176: IS
177:
178: SELECT 'yes'
179: FROM dual
180: WHERE EXISTS (SELECT 'x'
181: FROM hxc_layouts_tl
182: WHERE layout_id = p_layout_id
183: and DISPLAY_LAYOUT_NAME <> P_DISPLAY_LAYOUT_NAME --added

Line 335: FROM dual

331: BEGIN
332: -- see if there is a TL row to update
333: SELECT 'yes'
334: INTO l_dummy
335: FROM dual
336: WHERE EXISTS (SELECT 'x'
337: FROM hxc_layouts_tl
338: WHERE layout_id = l_layout_id
339: and DISPLAY_LAYOUT_NAME <> P_DISPLAY_LAYOUT_NAME --added

Line 1020: FROM dual

1016:
1017: CURSOR c_display_name(p_layout_id IN NUMBER)
1018: IS
1019: SELECT 'yes'
1020: FROM dual
1021: WHERE EXISTS( SELECT 'x'
1022: FROM hxc_layouts_tl
1023: WHERE layout_id = p_layout_id
1024: AND display_layout_name <>

Line 1214: FROM dual

1210: BEGIN
1211: -- see if there is a TL row to update
1212: SELECT 'yes'
1213: INTO l_dummy
1214: FROM dual
1215: WHERE EXISTS( SELECT 'x'
1216: FROM hxc_layouts_tl
1217: WHERE layout_id = l_layout_id
1218: AND display_layout_name <>