APPS.FV_COPY_YE_RECORDS_PKG SQL Statements

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

Line: 14

 SELECT *
   FROM fv_ye_group_sequences
  WHERE group_id = v_old_group_id
  ORDER BY SEQUENCE;

Line: 21

 SELECT *
   FROM fv_ye_sequence_accounts
  WHERE sequence_id = cv_sequence_id
  ORDER BY order_by_ctr;

Line: 38

 SELECT fv_ye_groups_id_s.NEXTVAL
   INTO v_new_group_id
   FROM dual;

Line: 46

    SELECT  treasury_symbol_id
	INTO    v_treasury_symbol_id
	FROM    fv_treasury_symbols
	WHERE   treasury_symbol = v_treasury_symbol_new
	AND	set_of_books_id = v_ledger_id;

Line: 55

                                         'INSERTING TO FV_YE_GROUPS');

Line: 58

 INSERT INTO fv_ye_groups
 (group_id,
  set_of_books_id,
  fund_time_frame,
  fund_group_code,
  last_update_date,
  last_updated_by,
  last_update_login,
  creation_date,
  created_by,
  treasury_symbol_id)
 VALUES
 (v_new_group_id,
  v_ledger_id,
  v_time_frame_new,
  v_fund_group_code_new,
  TRUNC(SYSDATE),
  v_login,
  v_login,
  TRUNC(SYSDATE),
  v_login,
  v_treasury_symbol_id);

Line: 88

   SELECT fv_ye_group_sequences_s.NEXTVAL
     INTO v_sequence_id
     FROM dual;

Line: 92

   INSERT INTO fv_ye_group_sequences
   (sequence_id,
    group_id,
    SEQUENCE,
    set_of_books_id,
    last_update_date,
    last_updated_by,
    last_update_login,
    creation_date,
    created_by)
   VALUES
   (v_sequence_id,
    v_new_group_id,
    c_sequences_rec.SEQUENCE,
    v_ledger_id,
    TRUNC(SYSDATE),
    v_login,
    v_login,
    TRUNC(SYSDATE),
    v_login);

Line: 120

    INSERT INTO fv_ye_sequence_accounts
    (sequence_id,
     sequence_acct_id,
     account_flag,
     from_account,
     to_account,
     order_by_ctr,
     set_of_books_id,
     last_update_date,
     last_updated_by,
     last_update_login,
     creation_date,
     created_by)
    VALUES
    (v_sequence_id,
     fv_ye_sequence_acct_s.NEXTVAL,
     c_accounts_rec.account_flag,
     c_accounts_rec.from_account,
     c_accounts_rec.to_account,
     c_accounts_rec.order_by_ctr,
     v_ledger_id,
     TRUNC(SYSDATE),
     v_login,
     v_login,
     TRUNC(SYSDATE),
     v_login);