[Home] [Help]
549: FUNCTION Get_Group_ID RETURN number
550: IS
551: CURSOR gp_id IS
552: SELECT GL_INTERFACE_CONTROL_S.NEXTVAL
553: FROM sys.DUAL;
554: l_group_id number;
555: BEGIN
556: OPEN gp_id;
557: FETCH gp_id INTO l_group_id;
819: )
820: IS
821: CURSOR get_new_id IS
822: SELECT gl_je_posting_s.NEXTVAL
823: FROM sys.dual;
824:
825: cursor ledger is
826: select chart_of_accounts_id
827: from gl_ledgers