APPS.ENG_PERSON SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

  v_delete_permitted    varchar2(1);

Line: 21

        select 'Y'
        into    v_delete_permitted
        from    sys.dual
        where   not exists (
                select  null
                from    eng_engineering_changes eng
                where   eng.requestor_id in  (select party_id
                                            from hz_parties
                                            where person_identifier = to_char(p_person_id)));

Line: 39

        select 'Y'
        into    v_delete_permitted
        from    sys.dual
        where   not exists (
                select  null
                from    eng_current_scheduled_dates     eng
                where   eng.employee_id  in (select party_id
					    from hz_parties
		                            where person_identifier = to_char(p_person_id)));

Line: 57

        select 'Y'
        into    v_delete_permitted
        from    sys.dual
        where   not exists (
                select  null
                from    eng_ecn_approvers       eng
                where   eng.employee_id         = P_PERSON_ID);

Line: 73

        select 'Y'
        into    v_delete_permitted
        from    sys.dual
        where   not exists (
                select  null
                from    eng_eng_changes_interface       eng
                where   eng.requestor_id in (select party_id
                                            from hz_parties
                                            where person_identifier = to_char(p_person_id)));