APPS.HXC_ARCHIVE_RESTORE_UTILS SQL Statements

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

Line: 40

SELECT DISTINCT temp.time_building_block_id
FROM hxc_time_building_blocks temp, hxc_data_sets d
WHERE temp.scope = 'TIMECARD_TEMPLATE'
AND EXISTS (SELECT 1 FROM hxc_time_building_blocks tc
	    WHERE tc.scope = 'TIMECARD'
	      AND tc.time_building_block_id = temp.time_building_block_id
	      )
AND temp.stop_time BETWEEN d.start_date AND d.end_date
AND d.data_set_id = p_data_set_id;

Line: 103

  select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_PK ) parallel (t,4)*/ count(time_building_block_id)
  into p_tbb_count from hxc_time_building_blocks t;

Line: 107

  select/*+ index_ffs (t HXC_TIME_ATTRIBUTE_USAGES_PK ) parallel (t,4)*/ count(time_attribute_usage_id)
  into p_tau_count from hxc_time_attribute_usages t;

Line: 111

  select /*+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (t,4)*/ count(time_attribute_id)
  into p_ta_count from hxc_time_attributes t;

Line: 115

  select /*+ index_ffs (t HXC_TRANSACTION_DETAILS_PK ) parallel (t,4)*/ count(transaction_detail_id)
  into p_td_count from hxc_transaction_details t;

Line: 119

  select /*+ index_ffs (t HXC_TRANSACTIONS_PK ) parallel (t,4)*/ count(transaction_id)
  into p_trans_count from hxc_transactions t;

Line: 123

  select /*+ index_ffs (t HXC_TC_AP_LINKS_PK ) parallel (t,4)*/ count(timecard_id)
  into p_tal_count from hxc_tc_ap_links t;

Line: 127

  select /*+ index_ffs (t HXC_APP_PERIOD_SUMMARY_PK ) parallel (t,4)*/ count(application_period_id)
  into p_aps_count from hxc_app_period_summary t;

Line: 131

  select /*+ index_ffs (t HXC_AP_DETAIL_LINKS_PK ) parallel (t,4)*/ count(application_period_id)
  into p_adl_count from hxc_ap_detail_links t;

Line: 135

  select /*+ index_ffs (t HXC_LATEST_DETAILS_FK ) parallel (t,4)*/ count(time_building_block_id)
  into p_ld_count from hxc_latest_details t;

Line: 139

  select /*+ index_ffs (t HXC_TIMECARD_SUMMARY_PK ) parallel (t,4)*/ count(timecard_id)
  into p_ts_count from hxc_timecard_summary t;

Line: 179

  select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_AR_PK ) parallel (t,4)*/ count(time_building_block_id)
  into p_tbb_ar_count from hxc_time_building_blocks_ar t;

Line: 183

  select/*+ index_ffs (t HXC_TIME_ATTR_USAGES_AR_PK ) parallel (t,4)*/ count(time_attribute_usage_id)
  into p_tau_ar_count from hxc_time_attribute_usages_ar t;

Line: 187

  select /*+ index_ffs (t HXC_TIME_ATTRIBUTES_AR_PK ) parallel (t,4)*/ count(time_attribute_id)
  into p_ta_ar_count from hxc_time_attributes_ar t;

Line: 191

  select /*+ index_ffs (t HXC_TRANS_DETAILS_AR_PK ) parallel (t,4)*/ count(transaction_detail_id)
  into p_td_ar_count from hxc_transaction_details_ar t;

Line: 195

  select /*+ index_ffs (t HXC_TRANSACTIONS_AR_PK ) parallel (t,4)*/ count(transaction_id)
  into p_trans_ar_count from hxc_transactions_ar t;

Line: 199

  select /*+ index_ffs (t HXC_TC_AP_LINKS_AR_PK ) parallel (t,4)*/ count(timecard_id)
  into p_tal_ar_count from hxc_tc_ap_links_ar t;

Line: 203

  select /*+ index_ffs (t HXC_AP_DETAIL_LINKS_AR_PK ) parallel (t,4)*/ count(application_period_id)
  into p_adl_ar_count from hxc_ap_detail_links_ar t;

Line: 207

  select /*+ index_ffs (t HXC_APP_PERIOD_SUMMARY_AR_PK ) parallel (t,4)*/ count(application_period_id)
  into p_aps_ar_count from hxc_app_period_summary_ar t;

Line: 428

    SELECT /*+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (4)*/ count(ta.time_attribute_id)
    INTO l_att_diff_check
    FROM hxc_time_attributes ta, hxc_time_attributes_ar tabkup
    WHERE ta.time_attribute_id = tabkup.time_attribute_id
    AND EXISTS
    (SELECT 1 FROM hxc_time_attribute_usages tau
     WHERE tau.time_attribute_id = ta.time_attribute_id);

Line: 564

    SELECT  cr.request_id into l_running_id
    FROM
         fnd_concurrent_programs cp,
         fnd_concurrent_requests cr
    WHERE cp.concurrent_program_name in ('HXCCATTRB','HXCRESDS','HXCUNDEFDS','HXCDEFDS','HXCARCHDS')
    AND cp.application_id = 809
    AND
      cr.concurrent_program_id = cp.concurrent_program_id AND
      cr.request_id <> fnd_global.conc_request_id and
      cr.status_code = 'R';

Line: 598

SELECT DISTINCT notification_id
FROM WF_ITEM_ACTIVITY_STATUSES
WHERE ITEM_KEY = p_item_key
AND  ITEM_TYPE = p_item_type;

Line: 604

SELECT text_value
FROM wf_notification_attributes
WHERE notification_id = p_notification_id
and name = 'TIMECARD';

Line: 634

       update wf_notification_attributes set
       text_value = l_timecard_url
       where notification_id = l_notification_id
        and name = 'TIMECARD';