[Home] [Help]
APPS.PAYWSDYG_PKG dependencies on ALL_OBJECTS
Line 3923: l_pkg_status all_objects.status%type;
3919: cursor csr_pkg_exist(cp_pkg in varchar2) is
3920: select status from user_objects
3921: where object_type = 'PACKAGE BODY'
3922: and object_name = cp_pkg;
3923: l_pkg_status all_objects.status%type;
3924:
3925: l_need_rebuild_flag varchar2(15) := 'N';
3926: l_result boolean;
3927: l_prod_status varchar2(1);