DBA Data[Home] [Help]

APPS.HR_PUMP_META_MAPPER dependencies on USER_OBJECTS

Line 2027: from user_objects

2023: p_object_name in varchar2,
2024: p_object_type in varchar2
2025: ) is
2026: select status
2027: from user_objects
2028: where upper(object_name) = upper(p_object_name)
2029: and upper(object_type) = upper(p_object_type);
2030: l_status varchar2(64);
2031: begin

Line 4023: select 1 from user_objects

4019: select 1 from user_views
4020: where upper(view_name) = upper(p_view_name);
4021: --
4022: cursor csr_find_pkg( p_pkg_name in varchar2 ) is
4023: select 1 from user_objects
4024: where upper(object_name) = upper(p_pkg_name)
4025: and object_type = 'PACKAGE';
4026: --
4027: l_package_name varchar2(30);