APPS.PER_PCE_SHD SQL Statements

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

Line: 21

    SELECT cag.business_group_id
	FROM   per_collective_agreements cag
	WHERE  cag.collective_agreement_id = p_collective_agreement_id;

Line: 98

    select
       cagr_entitlement_id
      ,cagr_entitlement_item_id
      ,collective_agreement_id
      ,start_date
      ,end_date
      ,status
      ,formula_criteria
      ,formula_id
      ,units_of_measure
	  ,message_level
      ,object_version_number
    from        per_cagr_entitlements
    where       cagr_entitlement_id = p_cagr_entitlement_id;

Line: 174

    select
       cagr_entitlement_id
      ,cagr_entitlement_item_id
      ,collective_agreement_id
      ,start_date
      ,end_date
      ,status
      ,formula_criteria
      ,formula_id
      ,units_of_measure
	  ,message_level
      ,object_version_number
    from        per_cagr_entitlements
    where       cagr_entitlement_id = p_cagr_entitlement_id
    for update nowait;