APPS.PQH_CBR_ENGINE SQL Statements

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

Line: 54

   select calstart.start_date,calend.end_date,budget_unit1_value,budget_unit2_value,budget_unit3_value
   into   l_prd_start_date,l_prd_end_date,l_unit1_value,l_unit2_value,l_unit3_value
   from   pqh_budget_periods per,per_time_periods calstart, per_time_periods calend
   where  budget_period_id = p_budget_period_id
   and    per.start_time_period_id = calstart.time_period_id
   and    per.end_time_period_id  = calend.time_period_id;

Line: 164

   select count(*)
   into l_number
   from pqh_bdgt_pool_realloctions
   where pool_id = p_txn_id
   and   transaction_type = p_child_type;

Line: 180

   select sum(nvl(period.reallocation_amt,0)),sum(nvl(period.reserved_amt,0))
   into  p_donor_realloc_amt,p_donor_reserve_amt
   from  pqh_bdgt_pool_realloctions donor, pqh_bdgt_pool_realloctions period
   where donor.pool_id = p_txn_id
   and   period.txn_detail_id = donor.reallocation_id
   and   donor.transaction_type = 'D'
   and   period.transaction_type = 'DD' ;

Line: 188

   select sum(nvl(period.reallocation_amt,0))
   into  p_rcvr_realloc_amt
   from  pqh_bdgt_pool_realloctions rcvr, pqh_bdgt_pool_realloctions period
   where rcvr.pool_id = p_txn_id
   and   period.txn_detail_id = rcvr.reallocation_id
   and   rcvr.transaction_type = 'R'
   and   period.transaction_type = 'RD' ;

Line: 217

   select bgt.budget_id,bgt.budget_name,bgt.budgeted_entity_cd,bgt.budget_start_date,
          bgt.budget_end_date,bgt.currency_code,bgt.budget_unit1_id,bgt.budget_unit2_id,bgt.budget_unit3_id
   into   l_budget_id,p_budget_name,p_entity_type,p_budget_start_date,
          p_budget_end_date,p_budget_currency,l_budget_unit1_id,l_budget_unit2_id,l_budget_unit3_id
   from   pqh_budgets bgt, pqh_budget_versions bvr
   where  bgt.budget_id = bvr.budget_id
   and    bvr.budget_version_id = p_budget_version_id
   and    bgt.position_control_flag ='Y';

Line: 243

   select system_type_cd,shared_type_name
   into   p_bmu_name,p_budget_unit_name
   from   per_shared_types
   where  lookup_type ='BUDGET_MEASUREMENT_TYPE'
   and    shared_type_id = p_budget_unit_id;

Line: 267

  Select level,organization_id_parent
    From per_org_structure_elements
   where org_structure_version_id = p_org_structure_version_id
connect by prior organization_id_parent = organization_id_child
       and ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
  start with ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
        and organization_id_child = P_ORGANIZATION_ID
  UNION
  Select 0,p_organization_id
    from dual
  order by 1 asc;

Line: 328

   select rule_set_id
   into l_rule_set_id
   from pqh_rule_sets
   where business_group_id = p_business_group_id
     and organization_structure_id = p_organization_structure_id
     and starting_organization_id = p_starting_organization_id
     and rule_category =p_rule_category
     and rule_applicability = p_rule_applicability;

Line: 353

   select organization_id
   into l_organization_id
   from hr_all_positions_f
   where position_id = p_position_id
   and p_effective_date between effective_start_date and effective_end_date;

Line: 364

  Select org_structure_version_id
    From per_org_structure_versions
   Where organization_structure_id = p_org_structure_id
     AND version_number =
         (select max(version_number)
          From per_org_structure_versions
          Where organization_structure_id = p_org_structure_id);

Line: 403

   pqh_refresh_data.g_refresh_tab.DELETE;

Line: 434

   l_selected_value_v       varchar2(2000);

Line: 435

   l_selected_value_n       number;

Line: 436

   l_selected_value_d       date;

Line: 444

   select column_name, master_table_route_id,column_type
   into   l_column_name, l_table_route_id,l_column_type
   from   pqh_attributes
   where  attribute_id = p_attribute_id;

Line: 457

   select from_clause, where_clause
   into   l_from_clause, l_where_clause_in
   from   pqh_table_route where table_route_id = l_table_route_id;

Line: 477

    l_sel_stmt := 'select '||l_column_name||' from '||l_from_clause||' where '||l_where_clause_out ;

Line: 488

      execute immediate l_sel_stmt into l_selected_value_d;

Line: 490

      l_selected_value_v := fnd_date.date_to_canonical(l_selected_value_d);

Line: 493

      execute immediate l_sel_stmt into l_selected_value_n;

Line: 494

      l_selected_value_v := to_char(l_selected_value_n);

Line: 497

      execute immediate l_sel_stmt into l_selected_value_v;

Line: 499

   hr_utility.set_location('leaving with value: '||l_selected_value_v, 90);

Line: 500

   return l_selected_value_v;

Line: 879

select pool_id txn_id,name
from pqh_budget_pools
where parent_pool_id = p_folder_id;

Line: 884

select reallocation_id donor_id,budget_detail_id,entity_id
from pqh_bdgt_pool_realloctions
where pool_id = p_txn_id
and transaction_type ='D' ;

Line: 890

select reallocation_id rcvr_id,entity_id
from pqh_bdgt_pool_realloctions
where pool_id = p_txn_id
and transaction_type ='R' ;

Line: 896

select reallocation_amt,reserved_amt,budget_period_id
from pqh_bdgt_pool_realloctions
where txn_detail_id = p_donor_id
and pool_id is null
and transaction_type ='DD' ;

Line: 903

select reallocation_amt,entity_id,start_date,end_date,reallocation_id rcvr_period_id
from pqh_bdgt_pool_realloctions
where txn_detail_id = p_rcvr_id
and pool_id is null
and transaction_type ='RD' ;

Line: 929

   select count(*) into l_num_txns
   from pqh_budget_pools
   where parent_pool_id = p_transaction_id;

Line: 1301

   select rule_attribute_id,attribute_value,operation_code,attribute_code
   from pqh_rule_attributes
   where rule_set_id = p_rule_set_id;

Line: 1399

   select rule_set_id,organization_structure_id,starting_organization_id,organization_id,
          rule_set_name,rule_level_cd,rule_applicability
   from pqh_rule_sets
   where business_group_id  = p_business_group_id
   and   rule_category      = p_rule_category
   and   rule_applicability = p_rule_applicability
   and   rule_level_cd      <> 'I' ;

Line: 1408

   SELECT txndtl.budget_detail_id budget_detail_id,
          txndtl.entity_id        entity_id,
          txndtl.transaction_type txn_type,
          txndtl.pool_id          txn_id
   FROM pqh_budget_pools fld,
        pqh_budget_pools txn,
        pqh_bdgt_pool_realloctions txndtl
   WHERE fld.pool_id = p_transaction_id
   AND   fld.parent_pool_id IS NULL
   AND   fld.pool_id = txn.parent_pool_id
   AND   txn.pool_id = txndtl.pool_id;

Line: 1454

          select count(*) into l_rule_messages from pqh_rules where rule_set_id = l_rule_rec.rule_set_id;

Line: 1455

          select count(*) into l_rule_conditions from pqh_rule_attributes where rule_set_id = l_rule_rec.rule_set_id;

Line: 1461

             select message_name
             into l_message_cd
             from pqh_rules
             where rule_set_id = l_rule_rec.rule_set_id
             and application_id = 8302;

Line: 1520

   SELECT budget_version_id,budget_unit_id,name,business_group_id
   into   g_budget_version_id,l_budget_unit_id,g_folder_name,g_business_group_id
   FROM   pqh_budget_pools
   WHERE  pool_id = p_transaction_id
   and    parent_pool_id is null;

Line: 1548

      select tcat.txn_category_attribute_id tcat_attribute_id,
             att.attribute_id attribute_id,
             att.column_type column_type,
             att.column_name column_name
      from pqh_attributes att,pqh_txn_category_attributes tcat, pqh_transaction_categories txn
      where txn.transaction_category_id = tcat.transaction_category_id
        and txn.short_name = 'PQH_BPR'
        and txn.business_group_id is null
        and tcat.attribute_id = att.attribute_id
        and nvl(tcat.list_identifying_flag,'N') = 'N'
        and nvl(tcat.member_identifying_flag,'N') = 'N'
        and att.enable_flag ='Y';