APPS.PQH_PSF_BUS dependencies on PQH_BUDGET_PERIODS

Line 2123: from pqh_budget_periods bpr, per_time_periods tp_s,

2119: and bdt.budget_version_id = bvr.budget_version_id
2120: and bdt.position_id = p_position_id;
2121: cursor c3(p_budget_detail_id number) is
2122: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2123: from pqh_budget_periods bpr, per_time_periods tp_s,
2124: per_time_periods tp_e
2125: where bpr.budget_detail_id = p_budget_detail_id
2126: and tp_s.time_period_id = bpr.start_time_period_id
2127: and tp_e.time_period_id = bpr.end_time_period_id

Line 2211: from pqh_budget_periods bper,

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

Line 2280: from pqh_budget_periods bper,

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

Line 2350: from pqh_budget_periods bper,

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

Line 2421: from pqh_budget_periods bper,

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

Line 2582: from pqh_budget_periods bpr, per_time_periods tp_s,

2578: nvl(bdet.grade_id, -1);
2579:
2580: cursor c3(p_budget_detail_id number) is
2581: select bpr.budget_unit1_value, bpr.budget_unit2_value, bpr.budget_unit3_value
2582: from pqh_budget_periods bpr, per_time_periods tp_s,
2583: per_time_periods tp_e
2584: where bpr.budget_detail_id = p_budget_detail_id
2585: and tp_s.time_period_id = bpr.start_time_period_id
2586: and tp_e.time_period_id = bpr.end_time_period_id