APPS.PQH_PSF_BUS dependencies on PQH_BUDGET_VERSIONS

Line 2309: from pqh_budget_details bdt,pqh_budget_versions bvr

2305: --
2306: cursor c1(p_unit_id number) is select system_type_cd from
2307: per_shared_types where shared_type_id = p_unit_id;
2308: cursor c2(p_budget_id number) is select bdt.budget_detail_id
2309: from pqh_budget_details bdt,pqh_budget_versions bvr
2310: where bvr.budget_id = p_budget_id
2311: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date)
2312: and bdt.budget_version_id = bvr.budget_version_id
2313: and bdt.position_id = p_position_id;

Line 2760: from pqh_budget_details bdet,pqh_budget_versions bvr

2756: where shared_type_id = p_unit_id;
2757:
2758: cursor c2(p_budget_id number) is
2759: select bdet.budget_detail_id
2760: from pqh_budget_details bdet,pqh_budget_versions bvr
2761: where bvr.budget_id = p_budget_id
2762: and hr_general.effective_date between bvr.date_from and nvl(bvr.date_to,hr_general.effective_date)
2763: and bdet.budget_version_id = bvr.budget_version_id
2764: and nvl(p_organization_id, nvl(bdet.organization_id, -1)) =

Line 3097: from pqh_budget_details bdt,pqh_budget_versions bvr

3093: cursor c1(p_unit_id number) is select system_type_cd from
3094: per_shared_types where shared_type_id = p_unit_id;
3095: cursor c2(p_budget_id number) is
3096: select bdt.budget_detail_id, bdt.budget_unit1_value, bdt.budget_unit2_value, bdt.budget_unit3_value
3097: from pqh_budget_details bdt,pqh_budget_versions bvr
3098: where bvr.budget_id = p_budget_id
3099: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date)
3100: and bdt.budget_version_id = bvr.budget_version_id
3101: and bdt.position_id = p_position_id;

Line 3219: from pqh_budget_versions bvr

3215: hr_utility.set_location('start_date is '||to_char(l_start_date,'dd-MM-RRRR'),55);
3216: hr_utility.set_location('end_date is '||to_char(l_end_date,'dd-MM-RRRR'),60);
3217: --
3218: select budget_version_id into l_budget_version_id
3219: from pqh_budget_versions bvr
3220: where budget_id = l_budget_id
3221: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date);
3222: hr_utility.set_location('budget version exists' || l_budget_version_id, 70);
3223: open c1(l_budget_unit1_id);

Line 3341: from pqh_budget_versions bvr

3337: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
3338: );
3339: --
3340: select budget_version_id into l_budget_version_id
3341: from pqh_budget_versions bvr
3342: where budget_id = l_budget_id
3343: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date);
3344: open c1(l_budget_unit1_id);
3345: fetch c1 into l_unit1_name;

Line 4684: pqh_budget_versions bver,

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
4688: and bdet.position_id = p_position_id