[Home] [Help]
132: a.name,
133: a.start_date,
134: a.end_date
135: from PSB_BUDGET_YEAR_TYPES b,
136: PSB_BUDGET_PERIODS a
137: where b.budget_year_type_id = a.budget_year_type_id
138: and a.budget_period_type = 'Y'
139: and a.budget_calendar_id = p_budget_calendar_id
140: order by a.start_date;
142: cursor c_BudPrd (budyr_id NUMBER) is
143: select budget_period_id,
144: start_date,
145: end_date
146: from PSB_BUDGET_PERIODS
147: where budget_period_type = 'P'
148: and parent_budget_period_id = budyr_id
149: and budget_calendar_id = p_budget_calendar_id
150: order by start_date;
154: enddate DATE) is
155: select budget_period_id,
156: start_date,
157: end_date
158: from PSB_BUDGET_PERIODS
159: where end_date <= enddate
160: and start_date >= startdate
161: and budget_period_type = 'C'
162: and parent_budget_period_id = budyr_id
5388: cursor c_Type12 is
5389: select nvl(a.ytd_amount, 0) YTD_Amount
5390: from PSB_WS_ACCOUNT_LINES a,
5391: PSB_WORKSHEETS b,
5392: PSB_BUDGET_PERIODS c
5393: where a.code_combination_id = l_mapped_ccid
5394: and a.balance_type = p_balance_type
5395: and a.currency_code = p_currency_code
5396: and exists
5395: and a.currency_code = p_currency_code
5396: and exists
5397: (select 1
5398: from PSB_WORKSHEETS b,
5399: PSB_BUDGET_PERIODS c
5400: where b.worksheet_id = p_worksheet_id
5401: and a.stage_set_id = b.stage_set_id
5402: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5403: and c.budget_calendar_id = p_budget_calendar_id
5418: select sum(nvl(a.ytd_amount, 0)) YTD_Amount
5419: from PSB_WORKSHEETS b,
5420: PSB_WS_LINES d,
5421: PSB_WS_ACCOUNT_LINES a,
5422: PSB_BUDGET_PERIODS c
5423: where b.worksheet_id = p_worksheet_id
5424: and d.worksheet_id = b.worksheet_id
5425: and d.account_line_id = a.account_line_id
5426: and a.code_combination_id = l_mapped_ccid
5444: cursor c_Type12SP is
5445: select nvl(a.ytd_amount, 0) YTD_Amount
5446: from PSB_WS_ACCOUNT_LINES a,
5447: PSB_WORKSHEETS b,
5448: PSB_BUDGET_PERIODS c
5449: where a.code_combination_id = l_mapped_ccid
5450: and a.balance_type = p_balance_type
5451: and a.currency_code = p_currency_code
5452: and exists
5451: and a.currency_code = p_currency_code
5452: and exists
5453: (select 1
5454: from PSB_WORKSHEETS b,
5455: PSB_BUDGET_PERIODS c
5456: where b.worksheet_id = p_worksheet_id
5457: and a.stage_set_id = b.stage_set_id
5458: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5459: and c.budget_calendar_id = p_budget_calendar_id
5481: select sum(nvl(a.ytd_amount, 0)) YTD_Amount
5482: from PSB_WORKSHEETS b,
5483: PSB_WS_LINES d,
5484: PSB_WS_ACCOUNT_LINES a,
5485: PSB_BUDGET_PERIODS c
5486: where b.worksheet_id = p_worksheet_id
5487: and d.worksheet_id = b.worksheet_id
5488: and d.account_line_id = a.account_line_id
5489: and a.code_combination_id = l_mapped_ccid
7052: l_current_stage_seq := l_stage_rec.current_Stage_seq;
7053: END LOOP;
7054:
7055: FOR l_budget_period_rec IN (select budget_period_id, budget_year_type_id
7056: from psb_budget_periods
7057: where budget_calendar_id = p_budget_calendar_id
7058: and budget_period_type = 'Y'
7059: and parent_budget_period_id is null
7060: )