APPS.HR_SCH_ELIG_OBJ_PKG SQL Statements

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

Line: 86

  FUNCTION delete_sch_elig_obj(p_subscription_guid IN RAW
                              ,p_event             IN OUT NOCOPY wf_event_t
                              ) RETURN VARCHAR2 IS
    -- In Params
    l_bg_id          NUMBER;

Line: 107

      SELECT elig_obj_id
            ,object_version_number
      FROM ben_elig_obj_f
      WHERE business_group_id = cp_bg_id
      AND table_name = 'CAC_SR_SCHEDULES_VL'
      AND column_name = 'SCHEDULE_ID'
      AND column_value = cp_sch_id
      AND cp_eff_dt BETWEEN effective_start_date AND effective_end_date;

Line: 118

    l_routine := 'delete_sch_elig_obj';

Line: 127

    l_mode := 'DELETE';

Line: 139

      ben_elig_obj_api.delete_elig_obj
        (p_elig_obj_id           => l_elig_obj_id
        ,p_effective_date        => l_sch_start_date
        ,p_object_version_number => l_ovn
        ,p_datetrack_mode        => l_mode
        ,p_effective_start_date  => l_eff_start_dt
        ,p_effective_end_date    => l_eff_end_dt
        );

Line: 176

  END delete_sch_elig_obj;