APPS.OKI_UTL_PVT dependencies on GL_PERIODS

Line 53: -- Cursor to get the gl_periods based on period_set_name,

49: --------------------------------------------------------------------------------
50:
51: -- Global cursor declaration
52:
53: -- Cursor to get the gl_periods based on period_set_name,
54: -- period_type and p_summary_build_date between the start_date
55: -- and end_date
56: CURSOR g_glpr_csr
57: (

Line 61: ) RETURN gl_periods%ROWTYPE IS

57: (
58: p_period_set_name IN VARCHAR2
59: , p_period_type IN vARCHAR2
60: , p_summary_build_date IN DATE
61: ) RETURN gl_periods%ROWTYPE IS
62: SELECT *
63: FROM gl_periods glpr
64: WHERE glpr.adjustment_period_flag = 'N'
65: AND p_summary_build_date BETWEEN glpr.start_date AND glpr.end_date

Line 63: FROM gl_periods glpr

59: , p_period_type IN vARCHAR2
60: , p_summary_build_date IN DATE
61: ) RETURN gl_periods%ROWTYPE IS
62: SELECT *
63: FROM gl_periods glpr
64: WHERE glpr.adjustment_period_flag = 'N'
65: AND p_summary_build_date BETWEEN glpr.start_date AND glpr.end_date
66: AND glpr.period_set_name LIKE NVL(p_period_set_name, '%')
67: AND glpr.period_type LIKE NVL(p_period_type, '%')

Line 246: gl_periods glpr

242: -- Cursor to set the GL period start and end dates
243: CURSOR l_gl_period_csr IS
244: SELECT glpr.*
245: FROM
246: gl_periods glpr
247: , gl_sets_of_books sob
248: , hr_organization_information oin
249: WHERE
250: oki_utl_pub.g_summary_build_date BETWEEN glpr.start_date