APPS.PSB_POSITIONS_PVT dependencies on PSB_BUDGET_PERIODS

Line 4080: FROM psb_worksheets w,psb_budget_periods b

4076: FROM psb_worksheets
4077: WHERE worksheet_id = p_worksheet_id ;
4078: cursor calendar_csr IS
4079: SELECT min(start_date) , max(end_date)
4080: FROM psb_worksheets w,psb_budget_periods b
4081: WHERE b.budget_calendar_id = w.budget_calendar_id AND
4082: w.worksheet_id = l_out_worksheet_id AND
4083: budget_period_type = 'Y';
4084: cursor rev_csr IS

Line 4742: FROM psb_budget_periods bp

4738: /* --- Commented the following 11 Lines ---
4739: CURSOR c_Calc_Periods IS
4740: SELECt bp.start_date,
4741: bp.end_date
4742: FROM psb_budget_periods bp
4743: WHERE bp.budget_period_type = 'C'
4744: AND bp.budget_calendar_id = p_budget_calendar_id
4745: ORDER by bp.start_date;
4746: -- get calculation period (proposed year) for the calendar

Line 4814: psb_budget_periods a

4810: a.name,
4811: a.start_date,
4812: a.end_date
4813: FROM psb_budget_year_types b,
4814: psb_budget_periods a
4815: WHERE b.budget_year_type_id = a.budget_year_type_id
4816: AND a.budget_period_type = 'Y'
4817: AND a.budget_calendar_id = P_budget_calendar_id
4818: ORDER BY a.start_date)