APPS.PQH_EFC SQL Statements

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

Line: 30

SELECT currency_code
FROM per_business_groups
WHERE business_group_id = p_business_group_id;

Line: 36

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_budget_versions bvr
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = p_primary_key;

Line: 44

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     pqh_budget_details bdt
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = bdt.budget_version_id
  AND bdt.budget_detail_id  = p_primary_key;

Line: 54

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     pqh_budget_details bdt,
     pqh_budget_periods bpr
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = bdt.budget_version_id
  AND bdt.budget_detail_id  = bpr.budget_detail_id
  AND bpr.budget_period_id  = p_primary_key;

Line: 66

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     pqh_budget_details bdt,
     pqh_budget_periods bpr,
     pqh_budget_sets    bst
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = bdt.budget_version_id
  AND bdt.budget_detail_id  = bpr.budget_detail_id
  AND bpr.budget_period_id  = bst.budget_period_id
  AND bst.budget_set_id  = p_primary_key;

Line: 80

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_worksheets wks,
     pqh_worksheet_details wdt
WHERE bgt.budget_id = wks.budget_id
  AND wks.worksheet_id  = wdt.worksheet_id
  AND wdt.worksheet_detail_id  = p_primary_key;

Line: 90

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_worksheets wks,
     pqh_worksheet_details wdt,
     pqh_worksheet_periods wpr
WHERE bgt.budget_id = wks.budget_id
  AND wks.worksheet_id  = wdt.worksheet_id
  AND wdt.worksheet_detail_id = wpr.worksheet_detail_id
  AND wpr.worksheet_period_id  = p_primary_key;

Line: 102

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_worksheets wks,
     pqh_worksheet_details wdt,
     pqh_worksheet_periods wpr,
     pqh_worksheet_budget_sets wst
WHERE bgt.budget_id = wks.budget_id
  AND wks.worksheet_id  = wdt.worksheet_id
  AND wdt.worksheet_detail_id = wpr.worksheet_detail_id
  AND wpr.worksheet_period_id = wst.worksheet_period_id
  AND wst.worksheet_budget_set_id  = p_primary_key;

Line: 116

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     pqh_element_commitments pec
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = pec.budget_version_id
  AND pec.element_commitment_id = p_primary_key;

Line: 126

SELECT currency_code
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     pqh_budget_pools   bpl,
     pqh_bdgt_pool_realloctions bre
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = bpl.budget_version_id
  AND bre.pool_id  = bpl.pool_id
  AND bre.reallocation_id = p_primary_key;

Line: 138

SELECT currency_code
FROM pqh_criteria_rate_defn crd,
     pqh_rate_matrix_rates_f rmr
WHERE crd.criteria_rate_defn_id = rmr.criteria_rate_defn_id
  AND rmr.rate_matrix_rate_id = p_primary_key
  and rmr.effective_start_date = (
  Select min(rmr1.effective_start_date)
    From pqh_rate_matrix_rates_f rmr1
   Where rmr1.rate_matrix_rate_id = p_primary_key );

Line: 149

SELECT currency_code
FROM per_salary_survey_lines ssl
WHERE ssl.salary_survey_line_id = p_primary_key;

Line: 274

SELECT pst1.system_type_cd ,
       pst2.system_type_cd ,
       pst3.system_type_cd
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     per_shared_types_vl pst1 ,
     per_shared_types_vl pst2 ,
     per_shared_types_vl pst3
WHERE bgt.budget_id = bvr.budget_id
  AND bgt.budget_unit1_id = pst1.shared_type_id (+)
  AND bgt.budget_unit2_id = pst2.shared_type_id (+)
  AND bgt.budget_unit3_id = pst3.shared_type_id (+)
  AND bvr.budget_version_id = p_primary_key ;

Line: 290

SELECT pst1.system_type_cd ,
       pst2.system_type_cd ,
       pst3.system_type_cd
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     pqh_budget_details bdt,
     per_shared_types_vl pst1 ,
     per_shared_types_vl pst2 ,
     per_shared_types_vl pst3
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = bdt.budget_version_id
  AND bgt.budget_unit1_id = pst1.shared_type_id (+)
  AND bgt.budget_unit2_id = pst2.shared_type_id (+)
  AND bgt.budget_unit3_id = pst3.shared_type_id (+)
  AND bdt.budget_detail_id  = p_primary_key;

Line: 308

SELECT pst1.system_type_cd ,
       pst2.system_type_cd ,
       pst3.system_type_cd
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     pqh_budget_details bdt,
     pqh_budget_periods bpr,
     per_shared_types_vl pst1 ,
     per_shared_types_vl pst2 ,
     per_shared_types_vl pst3
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = bdt.budget_version_id
  AND bdt.budget_detail_id  = bpr.budget_detail_id
  AND bgt.budget_unit1_id = pst1.shared_type_id (+)
  AND bgt.budget_unit2_id = pst2.shared_type_id (+)
  AND bgt.budget_unit3_id = pst3.shared_type_id (+)
  AND bpr.budget_period_id  = p_primary_key;

Line: 328

SELECT pst1.system_type_cd ,
       pst2.system_type_cd ,
       pst3.system_type_cd
FROM pqh_budgets bgt,
     pqh_budget_versions bvr,
     pqh_budget_details bdt,
     pqh_budget_periods bpr,
     pqh_budget_sets    bst,
     per_shared_types_vl pst1 ,
     per_shared_types_vl pst2 ,
     per_shared_types_vl pst3
WHERE bgt.budget_id = bvr.budget_id
  AND bvr.budget_version_id = bdt.budget_version_id
  AND bdt.budget_detail_id  = bpr.budget_detail_id
  AND bpr.budget_period_id  = bst.budget_period_id
  AND bgt.budget_unit1_id = pst1.shared_type_id (+)
  AND bgt.budget_unit2_id = pst2.shared_type_id (+)
  AND bgt.budget_unit3_id = pst3.shared_type_id (+)
  AND bst.budget_set_id  = p_primary_key;

Line: 350

SELECT pst1.system_type_cd ,
       pst2.system_type_cd ,
       pst3.system_type_cd
FROM pqh_budgets bgt,
     pqh_worksheets wks,
     pqh_worksheet_details wdt,
     per_shared_types_vl pst1 ,
     per_shared_types_vl pst2 ,
     per_shared_types_vl pst3
WHERE bgt.budget_id = wks.budget_id
  AND wks.worksheet_id  = wdt.worksheet_id
  AND bgt.budget_unit1_id = pst1.shared_type_id (+)
  AND bgt.budget_unit2_id = pst2.shared_type_id (+)
  AND bgt.budget_unit3_id = pst3.shared_type_id (+)
  AND wdt.worksheet_detail_id  = p_primary_key;

Line: 368

SELECT pst1.system_type_cd ,
       pst2.system_type_cd ,
       pst3.system_type_cd
FROM pqh_budgets bgt,
     pqh_worksheets wks,
     pqh_worksheet_details wdt,
     pqh_worksheet_periods wpr,
     per_shared_types_vl pst1 ,
     per_shared_types_vl pst2 ,
     per_shared_types_vl pst3
WHERE bgt.budget_id = wks.budget_id
  AND wks.worksheet_id  = wdt.worksheet_id
  AND wdt.worksheet_detail_id = wpr.worksheet_detail_id
  AND bgt.budget_unit1_id = pst1.shared_type_id (+)
  AND bgt.budget_unit2_id = pst2.shared_type_id (+)
  AND bgt.budget_unit3_id = pst3.shared_type_id (+)
  AND wpr.worksheet_period_id  = p_primary_key;

Line: 388

SELECT pst1.system_type_cd ,
       pst2.system_type_cd ,
       pst3.system_type_cd
FROM pqh_budgets bgt,
     pqh_worksheets wks,
     pqh_worksheet_details wdt,
     pqh_worksheet_periods wpr,
     pqh_worksheet_budget_sets wst,
     per_shared_types_vl pst1 ,
     per_shared_types_vl pst2 ,
     per_shared_types_vl pst3
WHERE bgt.budget_id = wks.budget_id
  AND wks.worksheet_id  = wdt.worksheet_id
  AND wdt.worksheet_detail_id = wpr.worksheet_detail_id
  AND wpr.worksheet_period_id = wst.worksheet_period_id
  AND bgt.budget_unit1_id = pst1.shared_type_id (+)
  AND bgt.budget_unit2_id = pst2.shared_type_id (+)
  AND bgt.budget_unit3_id = pst3.shared_type_id (+)
  AND wst.worksheet_budget_set_id  = p_primary_key;

Line: 411

SELECT pst1.system_type_cd
FROM pqh_bdgt_pool_realloctions bre,
     pqh_budget_pools bpl,
     per_shared_types_vl pst1
WHERE bre.pool_id = bpl.pool_id
  AND bpl.budget_unit_id = pst1.shared_type_id
  AND bre.reallocation_id  = p_primary_key;

Line: 421

SELECT crd.uom
FROM pqh_criteria_rate_defn crd,
     pqh_rate_matrix_rates_f rmr
WHERE crd.criteria_rate_defn_id = rmr.criteria_rate_defn_id
  AND rmr.rate_matrix_rate_id = p_primary_key
  and rmr.effective_start_date = (
  Select min(rmr1.effective_start_date)
    From pqh_rate_matrix_rates_f rmr1
   Where rmr1.rate_matrix_rate_id = p_primary_key );

Line: 432

Select stock_display_type
from per_salary_survey_lines
Where salary_survey_line_id = p_primary_key;