APPS.PQH_PSF_BUS dependencies on PQH_BUDGET_DETAILS

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 2212: pqh_budget_details bdet,

2208: --
2209: cursor c_date is
2210: select stp.start_date
2211: from pqh_budget_periods bper,
2212: pqh_budget_details bdet,
2213: per_time_periods stp,
2214: per_time_periods etp
2215: where bper.budget_detail_id = bdet.budget_detail_id
2216: and p_position_id = bdet.position_id

Line 2281: pqh_budget_details bdet,

2277:
2278: cursor c_date is
2279: select stp.start_date
2280: from pqh_budget_periods bper,
2281: pqh_budget_details bdet,
2282: per_time_periods stp,
2283: per_time_periods etp
2284: where bper.budget_detail_id = bdet.budget_detail_id
2285: and p_job_id = bdet.job_id

Line 2351: pqh_budget_details bdet,

2347: cursor c_date is
2348:
2349: select stp.start_date
2350: from pqh_budget_periods bper,
2351: pqh_budget_details bdet,
2352: per_time_periods stp,
2353: per_time_periods etp
2354: where bper.budget_detail_id = bdet.budget_detail_id
2355: and p_organization_id = bdet.organization_id

Line 2422: pqh_budget_details bdet,

2418:
2419: cursor c_date is
2420: select stp.start_date
2421: from pqh_budget_periods bper,
2422: pqh_budget_details bdet,
2423: per_time_periods stp,
2424: per_time_periods etp
2425: where bper.budget_detail_id = bdet.budget_detail_id
2426: and p_grade_id = bdet.grade_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 4297: pqh_budget_details bdet

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
4301: and p_effective_date between bgt.budget_start_date and bgt.budget_end_date