APPS.HXC_HTR_UPLOAD_PKG dependencies on DUAL

Line 42: FROM dual

38: l_dummy NUMBER(1);
39:
40: CURSOR csr_chk_tab (p_hxc_schema in varchar2) IS
41: SELECT 1
42: FROM dual
43: WHERE EXISTS (
44: SELECT 1
45: FROM all_tables
46: WHERE owner = p_hxc_schema

Line 84: FROM dual

80: l_process VARCHAR2(30);
81:
82: CURSOR csr_chk_process ( p_process VARCHAR2 ) IS
83: SELECT 1
84: FROM dual
85: WHERE EXISTS (
86: SELECT 1
87: FROM user_objects
88: WHERE object_name = p_process