APPS.ARP_DATES dependencies on GL_SETS_OF_BOOKS

Line 175: gl_sets_of_books b,

171: l_all_pds_exist_sql := l_all_pds_exist_sql ||
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 || '

Line 249: gl_sets_of_books b,

245: 2
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''

Line 302: gl_sets_of_books b,

298: l_overlapping_pds_sql := l_overlapping_pds_sql ||
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

Line 443: gl_sets_of_books.set_of_books_id%type ) IS

439: ra_customer_trx_lines.accounting_rule_duration%type,
440: p_rule_start_date IN
441: ra_customer_trx_lines.rule_start_date%type,
442: p_sob_id IN
443: gl_sets_of_books.set_of_books_id%type ) IS
444: l_ai_flag boolean;
445: l_count integer;
446: l_result integer;
447:

Line 701: gl_sets_of_books b,

697: those periods which match with the type defined in the set of books*/
698: SELECT COUNT(gp1.period_set_name)
699: INTO actual_num_fiscal_year
700: FROM ra_customer_trx_lines ctl,
701: gl_sets_of_books b,
702: gl_periods gp1
703: WHERE ctl.customer_trx_id = p_customer_trx_id
704: AND ctl.set_of_books_id = b.set_of_books_id
705: AND gp1.period_set_name = b.period_set_name

Line 727: gl_sets_of_books b,

723: INTO p_candidate_date
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