DBA Data[Home] [Help]

APPS.PN_VAREN_UTIL dependencies on GL_PERIODS

Line 937: FROM gl_periods

933:
934: BEGIN
935: SELECT period_type
936: INTO p_period_type
937: FROM gl_periods
938: WHERE UPPER (period_set_name) = UPPER (p_gl_period_set_name)
939: AND UPPER (period_type) = UPPER (p_period_type) -- new condition
940: GROUP BY period_type
941: , period_set_name;

Line 1595: FROM gl_periods

1591: SELECT period_type
1592: , period_set_name
1593: INTO l_period_type
1594: , l_gl_period_set_name
1595: FROM gl_periods
1596: WHERE UPPER (period_set_name) = UPPER (p_gl_period_set_name)
1597: AND UPPER (period_type) = UPPER (p_period_type)
1598: GROUP BY period_type
1599: , period_set_name;