APPS.ARPT_SQL_FUNC_UTIL dependencies on GL_PERIOD_STATUSES

Line 1388: l_period_name gl_period_statuses.period_name%TYPE;

1384:
1385: FUNCTION get_period_name( p_gl_date IN DATE )
1386: RETURN VARCHAR2 IS
1387:
1388: l_period_name gl_period_statuses.period_name%TYPE;
1389:
1390: CURSOR c_period_name IS
1391: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/
1392: gps.period_name

Line 1391: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/

1387:
1388: l_period_name gl_period_statuses.period_name%TYPE;
1389:
1390: CURSOR c_period_name IS
1391: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/
1392: gps.period_name
1393: from gl_period_statuses gps,
1394: ar_system_parameters sp
1395: where gps.application_id = 222

Line 1393: from gl_period_statuses gps,

1389:
1390: CURSOR c_period_name IS
1391: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/
1392: gps.period_name
1393: from gl_period_statuses gps,
1394: ar_system_parameters sp
1395: where gps.application_id = 222
1396: and gps.adjustment_period_flag = 'N'
1397: and gps.set_of_books_id = sp.set_of_books_id