APPS.PSB_WS_ACCT2 dependencies on PSB_BUDGET_PERIODS

Line 3209: PSB_BUDGET_PERIODS c

3205: and a.template_id is null
3206: and exists
3207: (select 1
3208: from PSB_WORKSHEETS b,
3209: PSB_BUDGET_PERIODS c
3210: where b.worksheet_id = p_worksheet_id
3211: and a.stage_set_id = b.stage_set_id
3212: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
3213: and c.budget_calendar_id = p_budget_calendar_id

Line 3230: PSB_BUDGET_PERIODS c

3226: select sum(nvl(a.ytd_amount, 0)) YTD_Amount
3227: from PSB_WORKSHEETS b,
3228: PSB_WS_LINES d,
3229: PSB_WS_ACCOUNT_LINES a,
3230: PSB_BUDGET_PERIODS c
3231: where b.worksheet_id = p_worksheet_id
3232: and d.worksheet_id = b.worksheet_id
3233: and d.account_line_id = a.account_line_id
3234: and a.code_combination_id = l_mapped_ccid

Line 3265: from psb_budget_periods

3261:
3262: /* start bug 4256345 */
3263:
3264: FOR l_budget_period_rec IN (select budget_period_id
3265: from psb_budget_periods
3266: where budget_calendar_id = p_budget_calendar_id
3267: and budget_period_type = 'Y'
3268: and parent_budget_period_id is null
3269: and budget_year_type_id = p_budget_year_type_id)

Line 4110: PSB_BUDGET_PERIODS c,

4106: d.year_category_type,
4107: c.name -- Bug#4571412
4108: FROM PSB_WS_LINES a,
4109: PSB_WS_ACCOUNT_LINES b,
4110: PSB_BUDGET_PERIODS c,
4111: PSB_BUDGET_YEAR_TYPES d
4112: WHERE a.worksheet_id = p_worksheet_id
4113: AND b.account_line_id = a.account_line_id
4114: AND b.end_stage_seq is null

Line 5995: 'from PSB_BUDGET_PERIODS b ' ||

5991: 'where account_line_id = a.account_line_id ' ||
5992: 'and worksheet_id = ' || p_worksheet_id || ') ' ||
5993: 'and exists ' ||
5994: '(select 1 ' ||
5995: 'from PSB_BUDGET_PERIODS b ' ||
5996: 'where b.budget_calendar_id = ' || p_budget_calendar_id || ' ' ||
5997: 'and b.budget_year_type_id = ' || c_AllocRule_Rec.budget_year_type_id || ' ' ||
5998: 'and a.budget_year_id = b.budget_period_id)';
5999:

Line 7750: from PSB_BUDGET_PERIODS d

7746: where account_line_id = b.account_line_id
7747: and worksheet_id = p_worksheet_id)
7748: and exists
7749: (select 1
7750: from PSB_BUDGET_PERIODS d
7751: where d.budget_calendar_id = p_budget_calendar_id
7752: and d.budget_period_type = 'Y'
7753: and d.start_date >= c.effective_start_date
7754: and b.budget_year_id = d.budget_period_id)