APPS.PSB_WS_ACCT2 dependencies on PSB_WORKSHEETS

Line 2549: FROM psb_worksheets_v

2545: budget_calendar_id ,
2546: include_gl_commit_balance ,
2547: include_gl_oblig_balance ,
2548: include_gl_other_balance
2549: FROM psb_worksheets_v
2550: WHERE worksheet_id = p_worksheet_id
2551: )
2552: LOOP
2553: l_budget_by_position := l_ws_rec.budget_by_position;

Line 2617: psb_worksheets_v b

2613: FOR l_sp_rec IN
2614: (
2615: SELECT a.service_package_id
2616: FROM psb_service_packages a,
2617: psb_worksheets_v b
2618: WHERE a.base_service_package = 'Y'
2619: AND ( a.global_worksheet_id = b.worksheet_id
2620: OR
2621: a.global_worksheet_id = b.global_worksheet_id

Line 3208: from PSB_WORKSHEETS b,

3204: and a.end_stage_seq is null
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

Line 3227: from PSB_WORKSHEETS b,

3223:
3224: -- commented as a part of bug fix 4256345
3225: /* cursor c_Type12 is
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

Line 4078: from PSB_WORKSHEETS_V a,

4074: /* bug no 4256345 */
4075: a.stage_set_id,
4076: a.current_stage_seq
4077: /* bug no 4256345 */
4078: from PSB_WORKSHEETS_V a,
4079: PSB_BUDGET_GROUPS_V b
4080: where a.worksheet_id = p_worksheet_id
4081: and b.budget_group_id = a.budget_group_id;
4082:

Line 4423: from PSB_WORKSHEETS_V

4419: rounding_factor,
4420: gl_cutoff_period,
4421: num_years_to_allocate,
4422: budget_by_position
4423: from PSB_WORKSHEETS_V
4424: where worksheet_id = p_worksheet_id;
4425: */
4426:
4427: cursor c_SOB is

Line 4552: FROM psb_worksheets

4548: SELECT DECODE(global_worksheet_flag, 'Y', worksheet_id,
4549: global_worksheet_id) global_worksheet_id
4550: INTO
4551: l_global_worksheet_id
4552: FROM psb_worksheets
4553: WHERE worksheet_id = p_worksheet_id;
4554:
4555: SELECT gl_cutoff_period,
4556: allocrule_set_id allocrule_set_id,

Line 4572: FROM psb_worksheets

4568: l_flex_mapping_set_id,
4569: l_parameter_set_id,
4570: l_num_years_to_allocate,
4571: l_budget_by_position
4572: FROM psb_worksheets
4573: WHERE worksheet_id = l_global_worksheet_id;
4574:
4575: END IF;
4576: /* Bug 3543845 End */

Line 8062: from PSB_WORKSHEETS

8058: stage_set_id,
8059: current_stage_seq,
8060: budget_calendar_id,
8061: rounding_factor
8062: from PSB_WORKSHEETS
8063: where worksheet_id = p_worksheet_id;
8064:
8065: cursor c_BG is
8066: select nvl(set_of_books_id, root_set_of_books_id) set_of_books_id,