199: -- Rounding Option
200: BEGIN
201: SELECT l.meaning
202: INTO lv_rounding_option
203: FROM rg_lookups l, rg_reports r
204: WHERE r.report_id = pn_balance_sheet_id
205: AND l.lookup_type = 'ROUNDING_OPTION'
206: AND l.lookup_code = r.rounding_option;
207: EXCEPTION
254: --MINIMUM_DISPLAY_LEVEL
255: BEGIN
256: SELECT lk.lookup_code
257: INTO ln_minimum_display_level
258: FROM rg_reports rp, rg_lookups lk
259: WHERE rp.report_id = pn_balance_sheet_id
260: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
261: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
262: EXCEPTION
332: -- Rounding Option
333: BEGIN
334: SELECT l.meaning
335: INTO lv_rounding_option
336: FROM rg_lookups l, rg_reports r
337: WHERE r.report_id = pn_revenue_expenditure_id --parameter: pn_revenue_expenditure_id
338: AND l.lookup_type = 'ROUNDING_OPTION'
339: AND l.lookup_code = r.rounding_option;
340: EXCEPTION
387: --MINIMUM_DISPLAY_LEVEL
388: BEGIN
389: SELECT lk.lookup_code
390: INTO ln_minimum_display_level
391: FROM rg_reports rp, rg_lookups lk
392: WHERE rp.report_id = pn_revenue_expenditure_id --parameter: pn_revenue_expenditure_id
393: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
394: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
395: EXCEPTION
464: -- Rounding Option
465: BEGIN
466: SELECT l.meaning
467: INTO lv_rounding_option
468: FROM rg_lookups l, rg_reports r
469: WHERE r.report_id = pn_expenditure_detail_id --parameter: pn_expenditure_detail_id
470: AND l.lookup_type = 'ROUNDING_OPTION'
471: AND l.lookup_code = r.rounding_option;
472: EXCEPTION
519: --MINIMUM_DISPLAY_LEVEL
520: BEGIN
521: SELECT lk.lookup_code
522: INTO ln_minimum_display_level
523: FROM rg_reports rp, rg_lookups lk
524: WHERE rp.report_id = pn_expenditure_detail_id --parameter: pn_expenditure_detail_id
525: AND TO_CHAR(rp.minimum_display_level) = lk.lookup_code(+)
526: AND lk.lookup_type = 'GL_DISPLAY_LEVEL';
527: EXCEPTION