APPS.PQH_PSF_BUS dependencies on PQH_BUDGET_VERSIONS

Line 2116: from pqh_budget_details bdt,pqh_budget_versions bvr

2112: --
2113: cursor c1(p_unit_id number) is select system_type_cd from
2114: per_shared_types where shared_type_id = p_unit_id;
2115: cursor c2(p_budget_id number) is select bdt.budget_detail_id
2116: from pqh_budget_details bdt,pqh_budget_versions bvr
2117: where bvr.budget_id = p_budget_id
2118: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date)
2119: and bdt.budget_version_id = bvr.budget_version_id
2120: and bdt.position_id = p_position_id;

Line 2567: from pqh_budget_details bdet,pqh_budget_versions bvr

2563: where shared_type_id = p_unit_id;
2564:
2565: cursor c2(p_budget_id number) is
2566: select bdet.budget_detail_id
2567: from pqh_budget_details bdet,pqh_budget_versions bvr
2568: where bvr.budget_id = p_budget_id
2569: and hr_general.effective_date between bvr.date_from and nvl(bvr.date_to,hr_general.effective_date)
2570: and bdet.budget_version_id = bvr.budget_version_id
2571: and nvl(p_organization_id, nvl(bdet.organization_id, -1)) =

Line 2849: from pqh_budget_details bdt,pqh_budget_versions bvr

2845: cursor c1(p_unit_id number) is select system_type_cd from
2846: per_shared_types where shared_type_id = p_unit_id;
2847: cursor c2(p_budget_id number) is
2848: select bdt.budget_detail_id, bdt.budget_unit1_value, bdt.budget_unit2_value, bdt.budget_unit3_value
2849: from pqh_budget_details bdt,pqh_budget_versions bvr
2850: where bvr.budget_id = p_budget_id
2851: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date)
2852: and bdt.budget_version_id = bvr.budget_version_id
2853: and bdt.position_id = p_position_id;

Line 2971: from pqh_budget_versions bvr

2967: hr_utility.set_location('start_date is '||to_char(l_start_date,'dd-MM-RRRR'),55);
2968: hr_utility.set_location('end_date is '||to_char(l_end_date,'dd-MM-RRRR'),60);
2969: --
2970: select budget_version_id into l_budget_version_id
2971: from pqh_budget_versions bvr
2972: where budget_id = l_budget_id
2973: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date);
2974: hr_utility.set_location('budget version exists' || l_budget_version_id, 70);
2975: open c1(l_budget_unit1_id);

Line 3093: from pqh_budget_versions bvr

3089: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
3090: );
3091: --
3092: select budget_version_id into l_budget_version_id
3093: from pqh_budget_versions bvr
3094: where budget_id = l_budget_id
3095: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date);
3096: open c1(l_budget_unit1_id);
3097: fetch c1 into l_unit1_name;

Line 4296: pqh_budget_versions bver,

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