APPS.HXC_HRP_SHD SQL Statements

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

Line: 49

    select
       recurring_period_id
      ,name
      ,start_date
      ,end_date
      ,period_type
      ,duration_in_days
      ,object_version_number
    from	hxc_recurring_periods
    where	recurring_period_id = p_recurring_period_id;

Line: 121

    select
       recurring_period_id
      ,name
      ,start_date
      ,end_date
      ,period_type
      ,duration_in_days
      ,object_version_number
    from	hxc_recurring_periods
    where	recurring_period_id = p_recurring_period_id
    for	update nowait;