DBA Data[Home] [Help]

APPS.ARP_CREDIT_MEMO_MODULE dependencies on GL_DATE_PERIOD_MAP

Line 4473: gl_date_period_map inv,

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

Line 4474: gl_date_period_map cm

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