544: FUNCTION Get_Group_ID RETURN number
545: IS
546: CURSOR gp_id IS
547: SELECT GL_INTERFACE_CONTROL_S.NEXTVAL
548: FROM sys.DUAL;
549: l_group_id number;
550: BEGIN
551: OPEN gp_id;
552: FETCH gp_id INTO l_group_id;
814: )
815: IS
816: CURSOR get_new_id IS
817: SELECT gl_je_posting_s.NEXTVAL
818: FROM sys.dual;
819:
820: cursor ledger is
821: select chart_of_accounts_id
822: from gl_ledgers