APPS.HXC_LKR_SHD SQL Statements

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

Line: 60

    select
       locker_type_owner_id
      ,locker_type_requestor_id
      ,grant_lock
    from        hxc_locking_rules
    where       locker_type_owner_id = p_locker_type_owner_id
    and   locker_type_requestor_id = p_locker_type_requestor_id;

Line: 125

    select
       locker_type_owner_id
      ,locker_type_requestor_id
      ,grant_lock
    from        hxc_locking_rules
    where       locker_type_owner_id = p_locker_type_owner_id
    and   locker_type_requestor_id = p_locker_type_requestor_id
    for update nowait;