DBA Data[Home] [Help]

APPS.AR_RAAPI_UTIL dependencies on GL_SETS_OF_BOOKS

Line 1802: gl_sets_of_books c

1798: CURSOR c_cost_ctr_segmt IS
1799: SELECT b.segment_num
1800: FROM fnd_segment_attribute_values a ,
1801: fnd_id_flex_segments b ,
1802: gl_sets_of_books c
1803: WHERE a.id_flex_num = c.chart_of_accounts_id
1804: AND c.set_of_books_id = arp_global.sysparam.set_of_books_id
1805: AND a.application_id = 101
1806: AND a.id_flex_code = 'GL#'

Line 2760: gl_sets_of_books sob,

2756:
2757: CURSOR c_start_period IS
2758: SELECT p.start_date, p.new_period_num
2759: FROM ar_periods p,
2760: gl_sets_of_books sob,
2761: ar_period_types tp
2762: WHERE sob.period_set_name = p.period_set_name
2763: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2764: AND sob.accounted_period_type = p.period_type

Line 2771: gl_sets_of_books sob,

2767:
2768: CURSOR c_current_period (p_new_period_num NUMBER) IS
2769: SELECT p.start_date, p.end_date
2770: FROM ar_periods p,
2771: gl_sets_of_books sob,
2772: ar_period_types tp
2773: WHERE sob.period_set_name = p.period_set_name
2774: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2775: AND sob.accounted_period_type = p.period_type