[Home] [Help]
857: IF (posting_acct_seq_version_id IS NOT NULL) THEN
858: BEGIN
859: SELECT header_name || ':' || version_name
860: INTO posting_acct_seq_name
861: FROM fun_seq_versions
862: WHERE seq_version_id = posting_acct_seq_version_id;
863: EXCEPTION
864: WHEN NO_DATA_FOUND THEN NULL;
865: END;
869: IF (close_acct_seq_version_id IS NOT NULL) THEN
870: BEGIN
871: SELECT header_name || ':' || version_name
872: INTO close_acct_seq_name
873: FROM fun_seq_versions
874: WHERE seq_version_id = close_acct_seq_version_id;
875: EXCEPTION
876: WHEN NO_DATA_FOUND THEN NULL;
877: END;