APPS.PER_RES_SHD SQL Statements

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

Line: 48

    select
       cagr_entitlement_result_id
      ,assignment_id
      ,start_date
      ,end_date
      ,collective_agreement_id
      ,cagr_entitlement_item_id
      ,element_type_id
      ,input_value_id
      ,cagr_api_id
      ,cagr_api_param_id
      ,category_name
      ,cagr_entitlement_id
      ,cagr_entitlement_line_id
      ,value
      ,units_of_measure
      ,range_from
      ,range_to
      ,grade_spine_id
      ,parent_spine_id
      ,step_id
      ,from_step_id
      ,to_step_id
      ,beneficial_flag
      ,oipl_id
      ,chosen_flag
      ,column_type
      ,column_size
      ,cagr_request_id
      ,business_group_id
      ,legislation_code
      ,eligy_prfl_id
      ,formula_id
      ,object_version_number
    from        per_cagr_entitlement_results
    where       cagr_entitlement_result_id = p_cagr_entitlement_result_id;

Line: 146

    select
       cagr_entitlement_result_id
      ,assignment_id
      ,start_date
      ,end_date
      ,collective_agreement_id
      ,cagr_entitlement_item_id
      ,element_type_id
      ,input_value_id
      ,cagr_api_id
      ,cagr_api_param_id
      ,category_name
      ,cagr_entitlement_id
      ,cagr_entitlement_line_id
      ,value
      ,units_of_measure
      ,range_from
      ,range_to
      ,grade_spine_id
      ,parent_spine_id
      ,step_id
      ,from_step_id
      ,to_step_id
      ,beneficial_flag
      ,oipl_id
      ,chosen_flag
      ,column_type
      ,column_size
      ,cagr_request_id
      ,business_group_id
      ,legislation_code
      ,eligy_prfl_id
      ,formula_id
      ,object_version_number
    from        per_cagr_entitlement_results
    where       cagr_entitlement_result_id = p_cagr_entitlement_result_id
    for update nowait;