APPS.PQH_PSF_BUS dependencies on PQH_BUDGET_PERIODS

Line 2316: from pqh_budget_periods bpr, per_time_periods tp_s,

2312: and bdt.budget_version_id = bvr.budget_version_id
2313: and bdt.position_id = p_position_id;
2314: cursor c3(p_budget_detail_id number) is
2315: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2316: from pqh_budget_periods bpr, per_time_periods tp_s,
2317: per_time_periods tp_e
2318: where bpr.budget_detail_id = p_budget_detail_id
2319: and tp_s.time_period_id = bpr.start_time_period_id
2320: and tp_e.time_period_id = bpr.end_time_period_id

Line 2404: from pqh_budget_periods bper,

2400: l_budgeted_fte number;
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

Line 2473: from pqh_budget_periods bper,

2469: ) return number is
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

Line 2543: from pqh_budget_periods bper,

2539:
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

Line 2614: from pqh_budget_periods bper,

2610: ) return number is
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

Line 2775: from pqh_budget_periods bpr, per_time_periods tp_s,

2771: nvl(bdet.grade_id, -1);
2772:
2773: cursor c3(p_budget_detail_id number) is
2774: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2775: from pqh_budget_periods bpr, per_time_periods tp_s,
2776: per_time_periods tp_e
2777: where bpr.budget_detail_id = p_budget_detail_id
2778: and tp_s.time_period_id = bpr.start_time_period_id
2779: and tp_e.time_period_id = bpr.end_time_period_id