21: counter NUMBER;
22:
23: CURSOR line_count IS
24: SELECT 1
25: FROM DUAL
26: WHERE EXISTS (SELECT 1
27: FROM GL_ELIM_ACCOUNTS_MAP
28: WHERE journal_id = X_journal_id
29: AND line_number = X_lineno
80: counter NUMBER;
81:
82: CURSOR source_count IS
83: SELECT 1
84: FROM DUAL
85: WHERE EXISTS (SELECT 1
86: FROM GL_ELIM_ACCOUNTS_MAP
87: WHERE journal_id = X_journal_id
88: AND (rowid <> X_row_id OR X_row_id IS NULL)