DBA Data[Home] [Help]

APPS.HR_PUMP_META_MAPPER dependencies on USER_OBJECTS

Line 2024: from user_objects

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

Line 4019: select 1 from user_objects

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