73: || (reverse chronological order - newest change first)
74: */
75:
76:
77: l_coa gl_sets_of_books.chart_of_accounts_id%TYPE;
78:
79: CURSOR cur_coa IS SELECT chart_of_accounts_id FROM gl_sets_of_books
80: WHERE set_of_books_id = get_sob_id;
81:
75:
76:
77: l_coa gl_sets_of_books.chart_of_accounts_id%TYPE;
78:
79: CURSOR cur_coa IS SELECT chart_of_accounts_id FROM gl_sets_of_books
80: WHERE set_of_books_id = get_sob_id;
81:
82: BEGIN
83: OPEN cur_coa;
102: || (reverse chronological order - newest change first)
103: */
104:
105:
106: l_sname gl_sets_of_books.short_name%TYPE;
107:
108: CURSOR cur_sname IS SELECT short_name FROM gl_sets_of_books
109: WHERE set_of_books_id = get_sob_id;
110:
104:
105:
106: l_sname gl_sets_of_books.short_name%TYPE;
107:
108: CURSOR cur_sname IS SELECT short_name FROM gl_sets_of_books
109: WHERE set_of_books_id = get_sob_id;
110:
111: BEGIN
112: OPEN cur_sname;