[Home] [Help]
817: stage_set_id,
818: flex_mapping_set_id,
819: current_stage_seq,
820: local_copy_flag
821: from PSB_WORKSHEETS_V
822: where worksheet_id = p_worksheet_id;
823: */
824:
825: cursor c_sp is
1002: l_local_copy_flag,
1003: /* start bug 3871839 */
1004: l_current_stage_seq
1005: /* end bug 3871839 */
1006: FROM psb_worksheets
1007: WHERE worksheet_id = p_worksheet_id;
1008:
1009: SELECT gl_cutoff_period,
1010: allocrule_set_id allocrule_set_id,
1022: l_stage_set_id,
1023: l_flex_mapping_set_id
1024: /* Bug No :3871839 Commented out l_current_stage_sequence */
1025: /*l_current_stage_seq*/
1026: FROM psb_worksheets
1027: WHERE worksheet_id = l_global_worksheet_id;
1028:
1029: END IF;
1030: /* Bug 3458191 end */
2614: a.flex_mapping_set_id,
2615: a.gl_cutoff_period,
2616: nvl(b.root_budget_group_id, b.budget_group_id) root_budget_group_id,
2617: local_copy_flag
2618: from PSB_WORKSHEETS_V a, PSB_BUDGET_GROUPS b
2619: where a.worksheet_id = p_worksheet_id
2620: and b.budget_group_id = a.budget_group_id;
2621: --
2622: cursor c_CCID is
5387: /* Existing Cursor definition is commented and modified one is added as follows :
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
5394: and a.balance_type = p_balance_type
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
5415: -- commenting the cursor
5416: /*
5417: cursor c_Type12 is
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
5443: /* Existing Cursor definition is commented and modified one is added as follows :
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
5450: and a.balance_type = p_balance_type
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
5478:
5479: /*
5480: cursor c_Type12SP is
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
5597:
5598: cursor c_Sum is
5599: select sum(nvl(a.ytd_amount,0)) Sum_Acc
5600: from PSB_WS_ACCOUNT_LINES a,
5601: PSB_WORKSHEETS b
5602: where exists
5603: (select 1
5604: from PSB_WS_LINES
5605: where account_line_id = a.account_line_id
5618:
5619: cursor c_SumSP is
5620: select sum(nvl(a.ytd_amount,0)) Sum_Acc
5621: from PSB_WS_ACCOUNT_LINES a,
5622: PSB_WORKSHEETS b
5623: where exists
5624: (select 1
5625: from PSB_WS_SUBMIT_SERVICE_PACKAGES c
5626: where c.service_package_id = a.service_package_id
5835: /* Bug 3608191 : Start */
5836: BEGIN
5837: SELECT global_worksheet_flag
5838: INTO l_global_ws_flag
5839: FROM psb_worksheets
5840: WHERE worksheet_id = p_worksheet_id;
5841: END;
5842:
5843: l_processed_flag := 'N';
7044: end loop;
7045:
7046: /* start bug 4256345 */
7047: FOR l_stage_rec IN ( SELECT stage_set_id, current_stage_seq
7048: FROM psb_worksheets
7049: WHERE worksheet_id = p_worksheet_id)
7050: LOOP
7051: l_stage_set_id := l_stage_rec.stage_set_id;
7052: l_current_stage_seq := l_stage_rec.current_Stage_seq;