APPS.FV_STATUS_OF_FUNDS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

  SELECT UPPER(application_column_name) application_column_name
  FROM fnd_id_flex_segments
  WHERE application_id = 101
  AND id_flex_code   = 'GL#'
  AND id_flex_num    = v_ca_id
  ORDER BY segment_num;

Line: 65

   SELECT  sum((nvl(glb.begin_balance_dr,0) - nvl(glb.begin_balance_cr,0)) +
           (nvl(glB.PERIOD_NET_DR,0) - nvl(glB.PERIOD_NET_cr,0))) bal_spend,
		decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg1,
		decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg2,
		decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg3
   FROM     gl_BALANCES               glB,
            gl_code_combinations      glc
   WHERE    glb.code_combination_id = glc.code_combination_id
   AND	    glc.chart_of_accounts_id 	 = v_ca_id
   AND      glb.ledger_id                = sob_id
   AND      glb.currency_code            = curr_code
   AND      glb.actual_flag              = 'A'
   AND      glc.enabled_flag             = 'Y'
   AND      glc.template_id  IS NULL
   AND      glb.period_name              = pd_name
   AND      decode(bal_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) = v_fund_value
   AND 	decode(acct_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30)
				between v_value_low and v_value_high
   group by decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		   decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		    decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) ;

Line: 201

   SELECT  sum((nvl(glb.begin_balance_dr,0) - nvl(glb.begin_balance_cr,0)) +
           (nvl(glB.PERIOD_NET_DR,0) - nvl(glB.PERIOD_NET_cr,0))) bal_bud,
		decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg1,
		decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg2,
		decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg3
   FROM     gl_BALANCES               glB,
            gl_code_combinations      glc
   WHERE    glb.code_combination_id = glc.code_combination_id
   AND	    glc.chart_of_accounts_id 	 = v_ca_id
   AND      glb.ledger_id           = sob_id
   AND      glb.currency_code       = curr_code
   AND      glb.actual_flag         = 'A'
   AND      glc.enabled_flag        = 'Y'
   AND      glc.template_id  IS NULL
   AND      glb.period_name         = pd_name
   AND      decode(bal_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) = v_fund_value
   AND 	decode(acct_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30)
				between v_value_low and v_value_high
	group by decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		   decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		    decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) ;

Line: 337

   SELECT  sum((nvl(glb.begin_balance_dr,0) - nvl(glb.begin_balance_cr,0)) +
           (nvl(glB.PERIOD_NET_DR,0) - nvl(glB.PERIOD_NET_cr,0))) bal_trans,
		decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg1,
		decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg2,
		decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg3
   FROM    gl_balances			glB,
	    gl_code_combinations	glc
   WHERE    glb.code_combination_id = glc.code_combination_id
   AND	    glc.chart_of_accounts_id 	 = v_ca_id
   AND      glb.ledger_id           = sob_id
   AND      glb.currency_code       = curr_code
   AND      glb.actual_flag         = 'A'
   AND      glc.enabled_flag        = 'Y'
   AND      glc.template_id  IS NULL
   AND      glb.period_name         = pd_name
   AND      decode(bal_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) = v_fund_value
   AND 	decode(acct_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30)
				between v_value_low and v_value_high
	group by decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		   decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		    decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) ;

Line: 473

   SELECT sum(nvl(accounted_dr,0) - nvl(accounted_cr,0)) pac_spend,
		decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg1,
		decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg2,
		decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg3
   FROM 	gl_bc_packets pac,
      	gl_code_combinations glc
   WHERE pac.code_combination_id = glc.code_combination_id
   AND	 glc.chart_of_accounts_id = v_ca_id
   AND      pac.ledger_id           = sob_id
   AND      pac.currency_code       = curr_code
   AND      pac.actual_flag         = 'A'
   AND      pac.status_code         in ('A','P')
   AND      glc.enabled_flag        = 'Y'
   AND      glc.template_id  IS NULL
   AND      substr(period_year,3,2) = substr(pd_name,8,2)
   AND      period_num between 1 and x_period_num
   AND      decode(bal_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) = v_fund_value
   AND 	decode(acct_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30)
				between v_value_low and v_value_high
   group by decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		   decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		    decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) ;

Line: 611

   SELECT	sum(nvl(accounted_dr,0) - nvl(accounted_cr,0)) pac_bud,
		decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg1,
		decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg2,
		decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) pg3
   FROM	gl_bc_packets pac,
      	gl_code_combinations glc
   WHERE pac.code_combination_id = glc.code_combination_id
   AND      pac.ledger_id           = sob_id
   AND	    glc.chart_of_accounts_id 	 = v_ca_id
   AND      pac.currency_code       = curr_code
   AND      pac.actual_flag         = 'A'
   AND      pac.status_code         in ('A','P')
   AND      glc.enabled_flag        = 'Y'
   AND      glc.template_id  IS NULL
   AND      substr(period_year,3,2) = substr(pd_name,8,2)
   AND      period_num between 1 and x_period_num
   AND      decode(bal_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) = v_fund_value
   AND 	decode(acct_seg_name,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30)
				between v_value_low and v_value_high
    group by decode(v_pagebreak_seg1,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		   decode(v_pagebreak_seg2,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30),
		    decode(v_pagebreak_seg3,'SEGMENT1',glc.segment1,'SEGMENT2',glc.segment2,
				'SEGMENT3',glc.segment3,'SEGMENT4',glc.segment4,
				'SEGMENT5',glc.segment5,'SEGMENT6',glc.segment6,
				'SEGMENT7',glc.segment7,'SEGMENT8',glc.segment8,
				'SEGMENT9',glc.segment9,'SEGMENT10',glc.segment10,
				'SEGMENT11',glc.segment11,'SEGMENT12',glc.segment12,
				'SEGMENT13',glc.segment13,'SEGMENT14',glc.segment14,
				'SEGMENT15',glc.segment15,'SEGMENT16',glc.segment16,
				'SEGMENT17',glc.segment17,'SEGMENT18',glc.segment18,
				'SEGMENT19',glc.segment19,'SEGMENT20',glc.segment20,
				'SEGMENT21',glc.segment21,'SEGMENT22',glc.segment22,
				'SEGMENT23',glc.segment23,'SEGMENT24',glc.segment24,
				'SEGMENT25',glc.segment25,'SEGMENT26',glc.segment26,
				'SEGMENT27',glc.segment27,'SEGMENT28',glc.segment28,
				'SEGMENT29',glc.segment29,'SEGMENT30',glc.segment30) ;

Line: 750

   SELECT 	fp.fund_value,
		fp.budget_authority,
		fp.transfers_in,
		fp.transfers_out,
		fp.unliquid_commitments,
		fp.unliquid_obligations,
		fp.expended_amount ,
		fp.treasury_symbol_id
   FROM   fv_fund_parameters fp
   WHERE  fp.set_of_books_id = sob_id
   AND    decode(rollup_type,'T',to_char(fp.treasury_symbol_id),'F',fp.fund_value)
     		between decode(rollup_type,'T',nvl(temp_v_treasury_symbol_id,fp.treasury_symbol_id),
          	'F',nvl(acct_ff_low,fp.fund_value) )
     		and decode(rollup_type,'T',nvl(temp_v_treasury_symbol_id,fp.treasury_symbol_id),
          	'F',nvl(acct_ff_high,fp.fund_value) );

Line: 768

    SELECT pagebk1,pagebk2,pagebk3,sum(acct_total) atot
    FROM fv_status_funds_temp
    GROUP BY pagebk1,pagebk2,pagebk3;

Line: 784

   	SELECT child_flex_value_low, child_flex_value_high
     	FROM fnd_flex_value_hierarchies
    	WHERE parent_flex_value = v_parent_value
      AND flex_value_set_id = parent_value_id;

Line: 794

   select substr(compiled_value_attributes,5,1)
   into v_sign
   from fnd_flex_values
   where flex_value = v_parent_value
   and flex_value_set_id = parent_value_id;

Line: 808

 DELETE FROM fv_status_funds_temp;

Line: 827

		INSERT INTO fv_status_funds_temp
			(pagebk1,pagebk2,pagebk3,acct_total) VALUES
			(c_balances_budget_rec.pg1,c_balances_budget_rec.pg2,
			 c_balances_budget_rec.pg3,
                         c_balances_budget_rec.bal_bud);

Line: 834

		INSERT INTO fv_status_funds_temp
			(pagebk1,pagebk2,pagebk3,acct_total) VALUES
			(c_packets_budget_rec.pg1,c_packets_budget_rec.pg2,
			 c_packets_budget_rec.pg3,c_packets_budget_rec.pac_bud);

Line: 852

		INSERT INTO fv_status_funds_temp
			(pagebk1,pagebk2,pagebk3,acct_total) VALUES
			(c_balances_budget_rec.pg1,c_balances_budget_rec.pg2,
			 c_balances_budget_rec.pg3,c_balances_budget_rec.bal_bud);

Line: 864

		INSERT INTO fv_status_funds_temp
			(pagebk1,pagebk2,pagebk3,acct_total) VALUES
			(c_packets_budget_rec.pg1,c_packets_budget_rec.pg2,
			 c_packets_budget_rec.pg3,c_packets_budget_rec.pac_bud);

Line: 878

		INSERT INTO fv_status_funds_final
		  (set_of_books_id,treasury_symbol,fund,pagebreak_seg1,
		   pagebreak_seg2,pagebreak_seg3,
		   treasury_symbol_id,
		   budget_auth_total)
		VALUES (sob_id1,v_treasury_symbol1,v_fund_value1,
			  c_get_temptable_info_rec.pagebk1,
			  c_get_temptable_info_rec.pagebk2,
			  c_get_temptable_info_rec.pagebk3,
			  v_treasury_symbol_id1,
		          decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));

Line: 907

		INSERT INTO fv_status_funds_final
		  (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
		  pagebreak_seg2,pagebreak_seg3,budget_auth_total)
		VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
			  c_get_temptable_info_rec.pagebk1,
			  c_get_temptable_info_rec.pagebk2,
			  c_get_temptable_info_rec.pagebk3,
		          decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));

Line: 940

   SELECT child_flex_value_low, child_flex_value_high
     FROM fnd_flex_value_hierarchies
    WHERE parent_flex_value = v_parent_value
      AND flex_value_set_id = parent_value_id;

Line: 951

   select substr(compiled_value_attributes,5,1)
   into v_sign
   from fnd_flex_values
   where flex_value = v_parent_value
   and flex_value_set_id = parent_value_id;

Line: 962

 DELETE FROM fv_status_funds_temp;

Line: 971

		INSERT INTO fv_status_funds_temp
		  (pagebk1,pagebk2,pagebk3,acct_total) VALUES
		  (c_balances_transfers_rec.pg1,c_balances_transfers_rec.pg2,
		  c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);

Line: 977

		INSERT INTO fv_status_funds_temp
		  (pagebk1,pagebk2,pagebk3,acct_total) VALUES
		  (c_packets_spending_rec.pg1,c_packets_spending_rec.pg2,
		  c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);

Line: 993

		INSERT INTO fv_status_funds_temp
		  (pagebk1,pagebk2,pagebk3,acct_total) VALUES
		  (c_balances_transfers_rec.pg1,c_balances_transfers_rec.pg2,
		  c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);

Line: 1005

		INSERT INTO fv_status_funds_temp
		  (pagebk1,pagebk2,pagebk3,acct_total) VALUES
		  (c_packets_spending_rec.pg1,c_packets_spending_rec.pg2,
		  c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);

Line: 1012

	    UPDATE fv_status_funds_final SET
	      transfers_in_total = decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot)
		WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
		AND   set_of_books_id = sob_id1
		AND	pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
		AND	pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
		AND	fund = v_fund_value1;

Line: 1026

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
			    pagebreak_seg2,pagebreak_seg3,transfers_in_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
                      c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));

Line: 1040

			UPDATE fv_status_funds_final SET
			  transfers_out_total =decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot)
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   set_of_books_id = sob_id1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND	fund = v_fund_value1;

Line: 1050

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
			    pagebreak_seg2,pagebreak_seg3,transfers_out_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
                      c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));

Line: 1070

			UPDATE fv_status_funds_final SET
			  transfers_in_total = decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot)
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   set_of_books_id = sob_id1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND   fund = v_fund_value1;

Line: 1080

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
			    pagebreak_seg2,pagebreak_seg3,transfers_in_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
                      c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));

Line: 1091

			UPDATE fv_status_funds_final SET
			  transfers_out_total = decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot)
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND   set_of_books_id = sob_id1
			AND   fund = v_fund_value1;

Line: 1101

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
			    pagebreak_seg2,pagebreak_seg3,transfers_out_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
                      c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));

Line: 1138

   SELECT child_flex_value_low, child_flex_value_high
   FROM fnd_flex_value_hierarchies
   WHERE parent_flex_value = v_parent_value
   AND flex_value_set_id = parent_value_id;

Line: 1147

 DELETE FROM fv_status_funds_temp;

Line: 1159

		INSERT INTO fv_status_funds_temp
		  (pagebk1,pagebk2,pagebk3,acct_total) VALUES
		  (c_balances_spending_rec.pg1,c_balances_spending_rec.pg2,
		  c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);

Line: 1172

		INSERT INTO fv_status_funds_temp
		  (pagebk1,pagebk2,pagebk3,acct_total) VALUES
		  (c_packets_spending_rec.pg1,c_packets_spending_rec.pg2,
		  c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);

Line: 1186

 		INSERT INTO fv_status_funds_temp
		  (pagebk1,pagebk2,pagebk3,acct_total) VALUES
		  (c_balances_spending_rec.pg1,c_balances_spending_rec.pg2,
		  c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);

Line: 1192

		INSERT INTO fv_status_funds_temp
		  (pagebk1,pagebk2,pagebk3,acct_total) VALUES
		  (c_packets_spending_rec.pg1,c_packets_spending_rec.pg2,
		  c_packets_spending_rec.pg3,c_packets_spending_rec.pac_spend);

Line: 1199

			UPDATE fv_status_funds_final SET
			  unliquid_comm_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND   set_of_books_id = sob_id1
			AND   fund = v_fund_value1;

Line: 1209

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
                      pagebreak_seg2,pagebreak_seg3,unliquid_comm_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
			    c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));

Line: 1225

			UPDATE fv_status_funds_final SET
			  unliquid_oblig_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND   set_of_books_id = sob_id1
			AND   fund = v_fund_value1;

Line: 1235

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
			    pagebreak_seg2,pagebreak_seg3,unliquid_oblig_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
			    c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));

Line: 1245

			UPDATE fv_status_funds_final SET
			  expen_amt_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND   set_of_books_id = sob_id1
			AND   fund = v_fund_value1;

Line: 1255

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
			    pagebreak_seg2,pagebreak_seg3,expen_amt_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
                      c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));

Line: 1274

			UPDATE fv_status_funds_final SET
			  unliquid_comm_total =  decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND   set_of_books_id = sob_id1
			AND   fund = v_fund_value1;

Line: 1284

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
                      pagebreak_seg2,pagebreak_seg3,unliquid_comm_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
			    c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));

Line: 1294

			UPDATE fv_status_funds_final SET
			  unliquid_oblig_total =  decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND   set_of_books_id = sob_id1
			AND   fund = v_fund_value1;

Line: 1304

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
			    pagebreak_seg2,pagebreak_seg3,unliquid_oblig_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
			    c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));

Line: 1315

			UPDATE fv_status_funds_final SET
			  expen_amt_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))
			WHERE pagebreak_seg1 = c_get_temptable_info_rec.pagebk1
			AND   pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
			AND   pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
			AND   set_of_books_id = sob_id1
			ANd   fund = v_fund_value1;

Line: 1325

			  INSERT INTO fv_status_funds_final
			    (set_of_books_id,treasury_symbol,treasury_symbol_id,fund,pagebreak_seg1,
			    pagebreak_seg2,pagebreak_seg3,expen_amt_total)
			  VALUES (sob_id1,v_treasury_symbol1,v_treasury_symbol_id1,v_fund_value1,
                      c_get_temptable_info_rec.pagebk1,
			    c_get_temptable_info_rec.pagebk2,
			    c_get_temptable_info_rec.pagebk3,
			    decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));

Line: 1354

  SELECT flex_value_set_id
  INTO  v_flex_value_id
  FROM fnd_id_flex_segments_vl
  WHERE id_flex_num = v_ca_id
    AND application_id = 101
    AND application_column_name = acct_seg_name
    AND id_flex_code='GL#';

Line: 1377

/* This procedure deletes all the rows from the fv_status_funds_final table.*/
/***************************************************************************/
PROCEDURE delete_from_final
IS
l_module_name varchar2(200) := g_module_name || 'delete_from_final';

Line: 1384

	delete from fv_status_funds_final;

Line: 1391

END delete_from_final;

Line: 1417

   delete_from_final;

Line: 1441

	SELECT treasury_symbol_id
	INTO  v_treasury_symbol_id
	FROM  fv_treasury_symbols
	WHERE  treasury_symbol = v_treasury_symbol
        AND    set_of_books_id=sob_id;

Line: 1450

   SELECT distinct(period_num)
   INTO   x_period_num
   FROM   gl_period_statuses
   WHERE  period_name = x_period_name
   AND	  ledger_id = sob_id
   AND	  application_id = 101;

Line: 1459

   SELECT chart_of_accounts_id
   INTO v_ca_id
   FROM gl_ledgers_public_v
   WHERE ledger_id = sob_id;

Line: 1569

	UPDATE fv_status_funds_final set
		--total_budgetary	= (nvl(budget_Auth_total,0) + nvl(transfers_in_total,0)) - nvl(transfers_out_total,0),
		total_budgetary	= (nvl(budget_Auth_total,0)) ,
		total_actuals	=  nvl(unliquid_comm_total,0) + nvl(unliquid_oblig_total,0) + nvl(expen_amt_total,0);

Line: 1573

	UPDATE fv_status_funds_final set
		funds_available	= nvl(total_budgetary,0) - nvl(total_actuals,0);