DBA Data[Home] [Help]

APPS.ARP_DATES dependencies on GL_PERIOD_TYPES

Line 176: gl_period_types t,

172: ' SELECT 1
173: FROM gl_periods p1, /* to get the first period */
174: gl_periods p2, /* to get the last period */
175: gl_sets_of_books b,
176: gl_period_types t,
177: ra_rules r
178: WHERE r.rule_id = ' || l_temp_rule || '
179: AND b.set_of_books_id = ' || l_temp_sob || '
180: AND ' || l_temp_rule_start_date || ' BETWEEN p1.start_date

Line 728: gl_period_types t,

724: FROM ra_customer_trx_lines ctl,
725: gl_periods gp1,
726: gl_periods gp2,
727: gl_sets_of_books b,
728: gl_period_types t,
729: ra_rules r,
730: ra_rule_schedules rl
731: WHERE ctl.customer_trx_id = p_customer_trx_id
732: AND ctl.accounting_rule_id = r.rule_id