DBA Data[Home] [Help]

APPS.AR_RAAPI_UTIL dependencies on GL_SETS_OF_BOOKS

Line 1801: gl_sets_of_books c

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

Line 2600: gl_sets_of_books sob,

2596:
2597: CURSOR c_start_period IS
2598: SELECT p.start_date, p.new_period_num
2599: FROM ar_periods p,
2600: gl_sets_of_books sob,
2601: ar_period_types tp
2602: WHERE sob.period_set_name = p.period_set_name
2603: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2604: AND sob.accounted_period_type = p.period_type

Line 2611: gl_sets_of_books sob,

2607:
2608: CURSOR c_current_period (p_new_period_num NUMBER) IS
2609: SELECT p.start_date, p.end_date
2610: FROM ar_periods p,
2611: gl_sets_of_books sob,
2612: ar_period_types tp
2613: WHERE sob.period_set_name = p.period_set_name
2614: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2615: AND sob.accounted_period_type = p.period_type