APPS.PQH_PSF_BUS dependencies on PQH_BUDGETS

Line 2142: from pqh_budgets

2138: );
2139:
2140: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2141: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
2142: from pqh_budgets
2143: where position_control_flag = 'Y'
2144: and budgeted_entity_cd = 'POSITION'
2145: and business_group_id = l_business_group_id
2146: and p_effective_date between budget_start_date and budget_end_date

Line 2595: from pqh_budgets

2591: begin
2592:
2593: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2594: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
2595: from pqh_budgets
2596: where position_control_flag = 'Y'
2597: and budgeted_entity_cd = p_budget_entity
2598: and business_group_id = p_business_group_id
2599: and p_effective_date between budget_start_date and budget_end_date

Line 2865: from pqh_budgets

2861: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 20);
2862: --
2863: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2864: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
2865: from pqh_budgets
2866: where position_control_flag = 'Y'
2867: and budgeted_entity_cd = 'POSITION'
2868: and business_group_id = l_business_group_id
2869: and p_effective_date between budget_start_date and budget_end_date

Line 2956: from pqh_budgets

2952: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2953: , budget_start_date, budget_end_date
2954: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
2955: ,l_start_date, l_end_date
2956: from pqh_budgets
2957: where position_control_flag = 'Y'
2958: and budgeted_entity_cd = 'POSITION'
2959: and business_group_id = l_business_group_id
2960: and p_effective_date between budget_start_date and budget_end_date

Line 3081: from pqh_budgets

3077: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
3078: , budget_start_date, budget_end_date
3079: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
3080: ,l_start_date, l_end_date
3081: from pqh_budgets
3082: where position_control_flag = 'Y'
3083: and budgeted_entity_cd = 'POSITION'
3084: and business_group_id = l_business_group_id
3085: and p_effective_date between budget_start_date and budget_end_date

Line 4295: from pqh_budgets bgt,

4291: p_effective_date date) is
4292: select bgt.budget_id, bgt.budget_name, bgt.business_group_id,
4293: bver.budget_version_id,
4294: bgt.budget_start_date, bgt.budget_end_date, bgt.currency_code
4295: from pqh_budgets bgt,
4296: pqh_budget_versions bver,
4297: pqh_budget_details bdet
4298: where bgt.budget_id = bver.budget_id
4299: and bver.budget_version_id = bdet.budget_version_id

Line 4455: l_budget_name pqh_budgets.budget_name%type;

4451: l_asg_organization_id number;
4452: l_asg_position_id number;
4453: --
4454: l_budget_id number;
4455: l_budget_name pqh_budgets.budget_name%type;
4456: l_business_group_id number;
4457: l_budget_version_id number;
4458: l_budget_start_date date;
4459: l_budget_end_date date;

Line 4460: l_currency_code pqh_budgets.currency_code%type;

4456: l_business_group_id number;
4457: l_budget_version_id number;
4458: l_budget_start_date date;
4459: l_budget_end_date date;
4460: l_currency_code pqh_budgets.currency_code%type;
4461: --
4462: l_salary_element_type_id number;
4463: l_salary_input_value_id number;
4464: --