1542: -- If no spec data is found, the gmd_coa_headers table will be empty
1543:
1544: CURSOR get_report_title IS
1545: select c.report_title, meaning
1546: from gem_lookups l, gmd_coa_headers c
1547: where l.lookup_type = 'GMD_COA_REPORT_TITLE'
1548: and l.lookup_code = c.report_title;
1549:
1550: CURSOR get_report_title_blank IS
1548: and l.lookup_code = c.report_title;
1549:
1550: CURSOR get_report_title_blank IS
1551: select meaning
1552: from gem_lookups l
1553: where l.lookup_type = 'GMD_COA_REPORT_TITLE'
1554: and l.lookup_code = 'BLK';
1555:
1556: