4469:
4470: SELECT NVL(inv.accounting_date, cm.accounting_date)
4471: INTO p_select_rec.rule_end_date
4472: FROM gl_sets_of_books sob,
4473: gl_date_period_map inv,
4474: gl_date_period_map cm
4475: WHERE sob.set_of_books_id = system_info.system_parameters.set_of_books_id
4476: AND cm.period_set_name = sob.period_Set_name
4477: AND cm.period_type = sob.accounted_period_type
4470: SELECT NVL(inv.accounting_date, cm.accounting_date)
4471: INTO p_select_rec.rule_end_date
4472: FROM gl_sets_of_books sob,
4473: gl_date_period_map inv,
4474: gl_date_period_map cm
4475: WHERE sob.set_of_books_id = system_info.system_parameters.set_of_books_id
4476: AND cm.period_set_name = sob.period_Set_name
4477: AND cm.period_type = sob.accounted_period_type
4478: AND cm.accounting_date = l_net_rev_gl_date