eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_MGMT_RPT_PKG SQL Statements

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

Line: 22


   Select system_type_cd
     From per_shared_types
    Where shared_type_id = p_unit_of_measure_id
     AND  lookup_type = 'BUDGET_MEASUREMENT_TYPE';

Line: 65


SELECT pqh_budget.get_currency_cd(bvr.budget_id)   CURRENCY_CODE
FROM    pqh_budget_versions bvr
WHERE   bvr.budget_version_id              = p_budget_version_id;

Line: 97


SELECT bdt.budget_unit1_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/* changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		       = 'POSITION'
  AND   bdt.position_id                    = p_position_id ;

Line: 123


SELECT  bdt.budget_unit2_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/* changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		       = 'POSITION'
  AND   bdt.position_id                    = p_position_id ;

Line: 150


SELECT bdt.budget_unit3_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.

pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe */
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		       = 'POSITION'
  AND   bdt.position_id                    = p_position_id ;

Line: 224


SELECT bdt.budget_unit1_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_job_id	   = bdt.job_id;

Line: 250


SELECT bdt.budget_unit2_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/* changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_job_id	   = bdt.job_id;

Line: 276


SELECT bdt.budget_unit3_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_job_id	   = bdt.job_id;

Line: 302


SELECT bdt.budget_unit1_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_grade_id	   = bdt.grade_id;

Line: 328


SELECT  bdt.budget_unit2_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_grade_id	   = bdt.grade_id;

Line: 354


SELECT bdt.budget_unit3_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023. Now budgeted values will be reported from budget details.

  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_grade_id	   = bdt.grade_id;

Line: 381


SELECT  bdt.budget_unit1_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.

pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_organization_id	   = bdt.organization_id;

Line: 408


SELECT bdt.budget_unit2_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023. Now budgeted values will be reported from budget details.

  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_organization_id	   = bdt.organization_id;

Line: 435


SELECT bdt.budget_unit3_value
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe
*/
WHERE
        bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
/*changed for bug#3784023. Now budgeted values will be reported from budget details.
  AND   bdt.budget_detail_id               = bpr.budget_detail_id
  AND   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
*/
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   p_organization_id	   = bdt.organization_id;

Line: 541


SELECT
 SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		       = 'POSITION'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.position_id                    = p_position_id ;

Line: 569


SELECT
 SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd	    	   = 'POSITION'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.position_id                    = p_position_id ;

Line: 597


SELECT
 SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		       = 'POSITION'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.position_id                    = p_position_id ;

Line: 671


SELECT
 SUM(bst.budget_unit1_value)
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		       = 'POSITION'
  AND   bst.dflt_budget_set_id             = p_budget_set_id
  AND   bdt.position_id                    = p_position_id ;

Line: 697


SELECT
 SUM(bst.budget_unit2_value )
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		       = 'POSITION'
  AND   bst.dflt_budget_set_id             = p_budget_set_id
  AND   bdt.position_id                    = p_position_id ;

Line: 723


SELECT
 SUM(bst.budget_unit3_value)
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id                = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		       = 'POSITION'
  AND   bst.dflt_budget_set_id             = p_budget_set_id
  AND   bdt.position_id                    = p_position_id ;

Line: 876


SELECT bvr.budget_id
FROM    pqh_budget_versions bvr
WHERE   bvr.budget_version_id              = p_budget_version_id;

Line: 881


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bgt.budget_id
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.position_id                    = p_position_id
  AND   bgt.budgeted_entity_cd		   = 'POSITION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 1047


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   bdt.job_id	   = p_job_id
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 1067


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   bdt.grade_id	   = p_grade_id
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 1087


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   bdt.organization_id = p_organization_id
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 1383


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   bdt.job_id	   = p_job_id
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 1404


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   bdt.grade_id	   = p_grade_id
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 1425


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = p_budgeted_entity_cd
  AND   bdt.organization_id	   = p_organization_id
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 1564


SELECT
 SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel

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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'JOB'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.job_id                         = p_job_id ;

Line: 1593


SELECT
 SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel


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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'JOB'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.job_id                         = p_job_id ;

Line: 1624


SELECT
 SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel


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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'JOB'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.job_id                         = p_job_id ;

Line: 1709


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(l_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.job_id                         = p_job_id
  AND   bgt.budgeted_entity_cd		   = 'JOB'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 1799


SELECT
 SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel

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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'GRADE'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.grade_id                       = p_grade_id ;

Line: 1828


SELECT
 SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel


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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'GRADE'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.grade_id                       = p_grade_id ;

Line: 1859


SELECT
 SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel


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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'GRADE'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.grade_id                       = p_grade_id ;

Line: 1948


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(l_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.grade_id                       = p_grade_id
  AND   bgt.budgeted_entity_cd		   = 'GRADE'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 2037


SELECT
 SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel

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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit1_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'ORGANIZATION'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.organization_id                = p_organization_id ;

Line: 2066


SELECT
 SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel


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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit2_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'ORGANIZATION'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.organization_id                = p_organization_id ;

Line: 2097


SELECT
 SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
per_time_periods                            ptps,
per_time_periods                            ptpe,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel


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   ptps.time_period_id                = bpr.start_time_period_id
  AND   ptpe.time_period_id                = bpr.end_time_period_id
  AND   bpr.budget_period_id               = bst.budget_period_id
  AND   bst.budget_set_id                  = bel.budget_set_id
  AND ( ptps.start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN ptps.start_date AND ptpe.end_date )
  AND   bvr.budget_version_id              = p_budget_version_id
  AND   bgt.budget_unit3_id        = p_unit_of_measure_id
  AND   bgt.budgeted_entity_cd		   = 'ORGANIZATION'
  AND   bel.element_type_id                = p_element_type_id
  AND   bdt.organization_id                = p_organization_id ;

Line: 2182


SELECT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(l_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.organization_id                = p_organization_id
  AND   bgt.budgeted_entity_cd		   = 'ORGANIZATION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 2318


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
WHERE
        bgt.business_group_id              = NVL(l_business_group_id, bgt.business_group_id )
  AND   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                  = bel.budget_set_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.position_id                    = p_position_id
  AND   bel.element_type_id                = p_element_type_id
  AND   bgt.budgeted_entity_cd		   = 'POSITION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 2437


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
WHERE
        bgt.business_group_id              = NVL(l_business_group_id, bgt.business_group_id )
  AND   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                  = bel.budget_set_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.job_id                         = p_job_id
  AND   bel.element_type_id                = p_element_type_id
  AND   bgt.budgeted_entity_cd		   = 'JOB'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 2554


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
WHERE
        bgt.business_group_id              = NVL(l_business_group_id, bgt.business_group_id )
  AND   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                  = bel.budget_set_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.grade_id                       = p_grade_id
  AND   bel.element_type_id                = p_element_type_id
  AND   bgt.budgeted_entity_cd		   = 'GRADE'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 2670


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
WHERE
        bgt.business_group_id              = NVL(l_business_group_id, bgt.business_group_id )
  AND   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                  = bel.budget_set_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.organization_id                = p_organization_id
  AND   bel.element_type_id                = p_element_type_id
  AND   bgt.budgeted_entity_cd		   = 'ORGANIZATION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 2773


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst
WHERE
        bgt.business_group_id              = NVL(l_business_group_id, bgt.business_group_id )
  AND   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                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.position_id                    = p_position_id
  AND   bst.dflt_budget_set_id             = p_budget_set_id
  AND   bgt.budgeted_entity_cd		   = 'POSITION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 2798


SELECT element_type_id
FROM pqh_dflt_budget_elements
WHERE dflt_budget_set_id  = p_budget_set_id;

Line: 2879


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.position_id                             position_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.organization_id                = p_organization_id
  AND   bgt.budgeted_entity_cd		   = 'POSITION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 2969


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.position_id                             position_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bdt.organization_id                = p_organization_id
  AND   bgt.budgeted_entity_cd		   = 'POSITION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3057


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.position_id                             position_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                      bgt,
pqh_budget_versions              bvr,
pqh_budget_details               bdt
WHERE bgt.business_group_id      = p_business_group_id
AND   bgt.budget_id              = bvr.budget_id
AND   bvr.budget_version_id      = bdt.budget_version_id
AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
       bgt.budget_unit2_id                = p_unit_of_measure_id or
       bgt.budget_unit3_id                = p_unit_of_measure_id)
AND   bgt.budgeted_entity_cd	 = 'POSITION'
AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
	OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3140


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.position_id                             position_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = p_business_group_id
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = 'POSITION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3227


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.position_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = 'POSITION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3323


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.job_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = 'JOB'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3419


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.grade_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = 'GRADE'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3515


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.organization_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   bgt.budget_id                      = bvr.budget_id
  AND   bvr.budget_version_id              = bdt.budget_version_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bgt.budgeted_entity_cd		   = 'ORGANIZATION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3613


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.position_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   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                  = bel.budget_set_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bel.element_type_id                = p_element_type_id
  AND   bgt.budgeted_entity_cd		   = 'POSITION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3721


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.job_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   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                  = bel.budget_set_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bel.element_type_id                = p_element_type_id
  AND   bgt.budgeted_entity_cd		   = 'JOB'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3828


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.grade_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   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                  = bel.budget_set_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bel.element_type_id                = p_element_type_id
  AND   bgt.budgeted_entity_cd		   = 'GRADE'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 3935


SELECT DISTINCT
bvr.BUDGET_VERSION_ID                       BUDGET_VERSION_ID,
bdt.organization_id,
pqh_budget.get_currency_cd(bgt.budget_id)   CURRENCY_CODE
FROM
pqh_budgets                                 bgt,
pqh_budget_versions                         bvr,
pqh_budget_details                          bdt,
pqh_budget_periods                          bpr,
pqh_budget_sets                             bst,
pqh_budget_elements                         bel
WHERE
        bgt.business_group_id              = NVL(p_business_group_id, bgt.business_group_id )
  AND   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                  = bel.budget_set_id
  AND   (bgt.budget_unit1_id                = p_unit_of_measure_id or
         bgt.budget_unit2_id                = p_unit_of_measure_id or
         bgt.budget_unit3_id                = p_unit_of_measure_id)
  AND   bel.element_type_id                = p_element_type_id
  AND   bgt.budgeted_entity_cd		   = 'ORGANIZATION'
  AND   hr_general.effective_date BETWEEN bvr.date_from AND bvr.date_to
  AND ( bgt.budget_start_date BETWEEN p_start_date AND p_end_date
        OR p_start_date  BETWEEN bgt.budget_start_date AND bgt.budget_end_date );

Line: 4221


	    l_posn_type := 'N';  -- Such records are not to be selected.

Line: 4228


	    l_posn_type := 'N';  -- Such records are not to be selected.

Line: 4358


	    l_entity_type := 'N';  -- Such records are not to be selected.

Line: 4365


	    l_entity_type := 'N';  -- Such records are not to be selected.

Line: 4497


	    l_entity_type := 'N';  -- Such records are not to be selected.

Line: 4504


	    l_entity_type := 'N';  -- Such records are not to be selected.

Line: 4634


	    l_entity_type := 'N';  -- Such records are not to be selected.

Line: 4641


	    l_entity_type := 'N';  -- Such records are not to be selected.

Line: 5088


 Select    Org.Name Org_name
   from    Hr_all_Positions_F pos, hr_all_organization_units_tl Org
  where    position_id          = p_position_id
    and    org.organization_id  = pos.organization_id
    and    language = userenv('LANG');