APPS.PSB_POSITION_CONTROL_PVT dependencies on PQH_PSB_BUDGET_PERIODS

Line 10195: from pqh_psb_budget_periods

10191: or ((b.start_date < a.start_date) and (b.end_date > a.end_date));
10192:
10193: cursor c_pqh_budget_periods (start_period_id NUMBER, end_period_id NUMBER) is
10194: select *
10195: from pqh_psb_budget_periods
10196: where budget_detail_id = p_pqh_budget_detail_id
10197: and start_time_period_id = start_period_id
10198: and end_time_period_id = end_period_id;
10199:

Line 11309: from pqh_psb_budget_periods

11305: begin
11306:
11307: for c_period_avg_rec in
11308: (select avg(budget_unit1_value) period_avg_value
11309: from pqh_psb_budget_periods
11310: where budget_detail_id = l_pqh_budget_detail_id) loop
11311: l_period_avg_value := c_period_avg_rec.period_avg_value;
11312: end loop;
11313:

Line 11342: from pqh_psb_budget_periods

11338: begin
11339:
11340: for c_period_avg_rec in
11341: (select avg(budget_unit2_value) period_avg_value
11342: from pqh_psb_budget_periods
11343: where budget_detail_id = l_pqh_budget_detail_id) loop
11344: l_period_avg_value := c_period_avg_rec.period_avg_value;
11345: end loop;
11346:

Line 11375: from pqh_psb_budget_periods

11371: begin
11372:
11373: for c_period_avg_rec in
11374: (select avg(budget_unit3_value) period_avg_value
11375: from pqh_psb_budget_periods
11376: where budget_detail_id = l_pqh_budget_detail_id) loop
11377: l_period_avg_value := c_period_avg_rec.period_avg_value;
11378: end loop;
11379: