eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PSF_BUS dependencies on PQH_BUDGET_DETAILS

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

2401: --
2402: cursor c_date is
2403: select stp.start_date
2404: from pqh_budget_periods bper,
2405: pqh_budget_details bdet,
2406: per_time_periods stp,
2407: per_time_periods etp
2408: where bper.budget_detail_id = bdet.budget_detail_id
2409: and p_position_id = bdet.position_id

Line 2474: pqh_budget_details bdet,

2470:
2471: cursor c_date is
2472: select stp.start_date
2473: from pqh_budget_periods bper,
2474: pqh_budget_details bdet,
2475: per_time_periods stp,
2476: per_time_periods etp
2477: where bper.budget_detail_id = bdet.budget_detail_id
2478: and p_job_id = bdet.job_id

Line 2544: pqh_budget_details bdet,

2540: cursor c_date is
2541:
2542: select stp.start_date
2543: from pqh_budget_periods bper,
2544: pqh_budget_details bdet,
2545: per_time_periods stp,
2546: per_time_periods etp
2547: where bper.budget_detail_id = bdet.budget_detail_id
2548: and p_organization_id = bdet.organization_id

Line 2615: pqh_budget_details bdet,

2611:
2612: cursor c_date is
2613: select stp.start_date
2614: from pqh_budget_periods bper,
2615: pqh_budget_details bdet,
2616: per_time_periods stp,
2617: per_time_periods etp
2618: where bper.budget_detail_id = bdet.budget_detail_id
2619: and p_grade_id = bdet.grade_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 4685: pqh_budget_details bdet

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