APPS.FVXBEGLS SQL Statements

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

Line: 42

  DELETE
    FROM fv_sf133_definitions_lines
   WHERE set_of_books_id = g_set_of_books_id;

Line: 47

  INSERT
    INTO fv_sf133_definitions_lines
        (sf133_line_id,
         set_of_books_id,
         sf133_line_number,
         sf133_line_label,
         sf133_line_type_code,
	   sf133_goals_line_number,
	   sf133_report_line_number,
         sf133_natural_balance_type,
         sf133_fund_category,
         created_by,
         creation_date,
     	 last_updated_by,
     	 last_update_date,
     	 last_update_login)
     SELECT fv_sf133_line_id_s.NEXTVAL,
            g_set_of_books_id,
            load.sf133_line_number,
            load.sf133_line_label,
            load.sf133_line_type_code,
		load.sf133_goals_line_number,
		load.sf133_report_line_number,
            load.sf133_natural_balance_type,
            load.sf133_fund_category,
            0,
            SYSDATE,
            0,
            SYSDATE,
            0
       FROM fv_sf133_load_lines load;

Line: 82

  DELETE
    FROM fv_sf133_definitions_accts
   WHERE (sf133_line_id)
             IN
         (SELECT set_of_books_id
            FROM fv_sf133_definitions_lines
           WHERE g_set_of_books_id = set_of_books_id);

Line: 94

    SELECT chart_of_accounts_id
      INTO v_flex_field_nbr
      FROM gl_sets_of_books
     WHERE set_of_books_id = g_set_of_books_id;

Line: 114

      INSERT
        INTO fv_sf133_definitions_accts
            (sf133_line_acct_id,
             sf133_line_id,
             sf133_balance_type,
             sf133_additional_info,
             created_by,
             creation_date,
             last_updated_by,
             last_update_date,
             last_update_login,
             segment1,
             segment2,
             segment3,
             segment4,
             segment5,
             segment6,
             segment7,
             segment8,
             segment9,
             segment10,
             segment11,
             segment12,
             segment13,
             segment14,
             segment15,
             segment16,
             segment17,
             segment18,
             segment19,
             segment20,
             segment21,
             segment22,
             segment23,
             segment24,
             segment25,
             segment26,
             segment27,
             segment28,
             segment29,
             segment30)
      SELECT fv_sf133_line_acct_id_s.NEXTVAL,
             line.sf133_line_id,
      	     load.sf133_balance_type,
	     load.sf133_additional_info,
             0,
             SYSDATE,
             0,
             SYSDATE,
             0,
             decode(v_account_segment_name,
                       'SEGMENT1',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT2',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT3',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT4',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT5',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT6',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT7',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT8',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT9',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT10',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT11',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT12',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT13',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT14',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT15',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT16',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT17',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT18',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT19',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT20',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT21',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT22',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT23',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT24',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT25',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT26',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT27',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT28',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT29',load.sf133_line_account, NULL),
             decode(v_account_segment_name,
                       'SEGMENT30',load.sf133_line_account, NULL)
        FROM fv_sf133_definitions_lines line,
             fv_sf133_load_accts        load
       WHERE line.sf133_line_number = load.sf133_line_number
         AND line.set_of_books_id   = g_set_of_books_id;