APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_BUDGET_PERIODS

Line 8030: -- check that HRMS budget periods are more granular than PSB budget periods

8026: END Validate_Budget_Group;
8027:
8028: /* ----------------------------------------------------------------------- */
8029:
8030: -- check that HRMS budget periods are more granular than PSB budget periods
8031:
8032: PROCEDURE Validate_Period_Granularity
8033: ( p_return_status OUT NOCOPY VARCHAR2,
8034: p_msg_count OUT NOCOPY NUMBER,

Line 8057: from psb_budget_periods

8053: and pc.period_set_name = pb.period_set_name;
8054:
8055: cursor c_psb_period_type is
8056: select min(period_distribution_type) psb_period_type
8057: from psb_budget_periods
8058: where budget_period_id between p_from_budget_year_id and p_to_budget_year_id
8059: and budget_period_type = 'Y';
8060:
8061: cursor c_psb_period is

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:

Line 11617: from psb_budget_periods

11613: /*For Bug No : 2292003 Start*/
11614: --added the budget_calendar_id filter
11615: cursor c_budget_period is
11616: select min(start_date) start_date, max(end_date) end_date
11617: from psb_budget_periods
11618: where budget_period_id between p_from_budget_year_id and p_to_budget_year_id
11619: and budget_calendar_id = l_budget_calendar_id
11620: and budget_period_type = 'Y';
11621: /*For Bug No : 2292003 End*/