APPS.PQH_PSF_BUS dependencies on PQH_BUDGETS

Line 2335: from pqh_budgets

2331: );
2332:
2333: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2334: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
2335: from pqh_budgets
2336: where position_control_flag = 'Y'
2337: and budgeted_entity_cd = 'POSITION'
2338: and business_group_id = l_business_group_id
2339: and p_effective_date between budget_start_date and budget_end_date

Line 2788: from pqh_budgets

2784: begin
2785:
2786: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
2787: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
2788: from pqh_budgets
2789: where position_control_flag = 'Y'
2790: and budgeted_entity_cd = p_budget_entity
2791: and business_group_id = p_business_group_id
2792: and p_effective_date between budget_start_date and budget_end_date

Line 3113: from pqh_budgets

3109: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 20);
3110: --
3111: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
3112: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
3113: from pqh_budgets
3114: where position_control_flag = 'Y'
3115: and budgeted_entity_cd = 'POSITION'
3116: and business_group_id = l_business_group_id
3117: and p_effective_date between budget_start_date and budget_end_date

Line 3204: from pqh_budgets

3200: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
3201: , budget_start_date, budget_end_date
3202: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
3203: ,l_start_date, l_end_date
3204: from pqh_budgets
3205: where position_control_flag = 'Y'
3206: and budgeted_entity_cd = 'POSITION'
3207: and business_group_id = l_business_group_id
3208: and p_effective_date between budget_start_date and budget_end_date

Line 3329: from pqh_budgets

3325: select budget_id, budget_unit1_id, budget_unit2_id, budget_unit3_id ,period_set_name
3326: , budget_start_date, budget_end_date
3327: into l_budget_id, l_budget_unit1_id, l_budget_unit2_id, l_budget_unit3_id, l_calendar
3328: ,l_start_date, l_end_date
3329: from pqh_budgets
3330: where position_control_flag = 'Y'
3331: and budgeted_entity_cd = 'POSITION'
3332: and business_group_id = l_business_group_id
3333: and p_effective_date between budget_start_date and budget_end_date

Line 4683: from pqh_budgets bgt,

4679: p_effective_date date) is
4680: select bgt.budget_id, bgt.budget_name, bgt.business_group_id,
4681: bver.budget_version_id,
4682: bgt.budget_start_date, bgt.budget_end_date, bgt.currency_code
4683: from pqh_budgets bgt,
4684: pqh_budget_versions bver,
4685: pqh_budget_details bdet
4686: where bgt.budget_id = bver.budget_id
4687: and bver.budget_version_id = bdet.budget_version_id

Line 4843: l_budget_name pqh_budgets.budget_name%type;

4839: l_asg_organization_id number;
4840: l_asg_position_id number;
4841: --
4842: l_budget_id number;
4843: l_budget_name pqh_budgets.budget_name%type;
4844: l_business_group_id number;
4845: l_budget_version_id number;
4846: l_budget_start_date date;
4847: l_budget_end_date date;

Line 4848: l_currency_code pqh_budgets.currency_code%type;

4844: l_business_group_id number;
4845: l_budget_version_id number;
4846: l_budget_start_date date;
4847: l_budget_end_date date;
4848: l_currency_code pqh_budgets.currency_code%type;
4849: --
4850: l_salary_element_type_id number;
4851: l_salary_input_value_id number;
4852: --