APPS.HXC_APC_SHD SQL Statements

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

Line: 80

    select
       approval_period_comp_id
      ,time_recipient_id
      ,recurring_period_id
      ,approval_period_set_id
      ,object_version_number
    from	hxc_approval_period_comps
    where	approval_period_comp_id = p_approval_period_comp_id;

Line: 150

    select
       approval_period_comp_id
      ,time_recipient_id
      ,recurring_period_id
      ,approval_period_set_id
      ,object_version_number
    from	hxc_approval_period_comps
    where	approval_period_comp_id = p_approval_period_comp_id
    for	update nowait;