[Home] [Help]
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
181: AND p1.end_date
246: )
247: )
248: FROM gl_periods p,
249: gl_sets_of_books b,
250: ra_rules r,
251: ra_rule_schedules rl
252: WHERE r.rule_id =' || l_temp_rule || '
253: AND r.frequency =''SPECIFIC''
254: AND rl.rule_id = r.rule_id
299: ' SELECT 1
300: FROM gl_periods p1,
301: gl_periods p2,
302: gl_sets_of_books b,
303: ra_rules r
304: WHERE r.rule_id = ' || l_temp_rule || '
305: AND b.set_of_books_id = ' || l_temp_sob || '
306: AND p1.period_set_name = b.period_set_name
307: AND p1.period_type = DECODE(
433: +===========================================================================*/
434:
435: PROCEDURE val_gl_periods_for_rules(
436: p_request_id IN ra_customer_trx.request_id%type,
437: p_acc_rule_id IN ra_rules.rule_id%type,
438: p_acc_duration IN
439: ra_customer_trx_lines.accounting_rule_duration%type,
440: p_rule_start_date IN
441: ra_customer_trx_lines.rule_start_date%type,
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
733: AND rl.rule_id (+) = decode(r.frequency,