APPS.ARPT_SQL_FUNC_UTIL dependencies on GL_PERIOD_STATUSES

Line 1478: l_period_name gl_period_statuses.period_name%TYPE;

1474:
1475: FUNCTION get_period_name( p_gl_date IN DATE )
1476: RETURN VARCHAR2 IS
1477:
1478: l_period_name gl_period_statuses.period_name%TYPE;
1479:
1480: CURSOR c_period_name IS
1481: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/
1482: gps.period_name

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

1477:
1478: l_period_name gl_period_statuses.period_name%TYPE;
1479:
1480: CURSOR c_period_name IS
1481: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/
1482: gps.period_name
1483: from gl_period_statuses gps,
1484: ar_system_parameters sp
1485: where gps.application_id = 222

Line 1483: from gl_period_statuses gps,

1479:
1480: CURSOR c_period_name IS
1481: select /*+use_nl(sp,gps) index(gps gl_period_statuses_u1)*/
1482: gps.period_name
1483: from gl_period_statuses gps,
1484: ar_system_parameters sp
1485: where gps.application_id = 222
1486: and gps.adjustment_period_flag = 'N'
1487: and gps.set_of_books_id = sp.set_of_books_id