APPS.PNP_UTIL_FUNC dependencies on GL_PERIOD_STATUSES

Line 5319: l_gl_period_name gl_period_statuses.period_name%TYPE;

5315: p_application_id IN NUMBER,
5316: p_org_id IN NUMBER
5317: ) RETURN VARCHAR2 IS
5318:
5319: l_gl_period_name gl_period_statuses.period_name%TYPE;
5320: l_err_msg VARCHAR2(2000);
5321:
5322: BEGIN
5323:

Line 5329: FROM gl_period_statuses

5325: AND end date of an open GL period. */
5326:
5327: SELECT period_name
5328: INTO l_gl_period_name
5329: FROM gl_period_statuses
5330: WHERE closing_status IN ('O', 'F')
5331: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5332: p_org_id)
5333: AND application_id = p_application_id

Line 5350: FROM gl_period_statuses

5346: next open GL period name is seleted. */
5347:
5348: SELECT period_name
5349: INTO l_gl_period_name
5350: FROM gl_period_statuses
5351: WHERE closing_status IN ('O', 'F')
5352: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5353: p_org_id)
5354: AND application_id = p_application_id

Line 5357: FROM gl_period_statuses

5353: p_org_id)
5354: AND application_id = p_application_id
5355: AND adjustment_period_flag = 'N'
5356: AND start_date = (SELECT MIN(start_date)
5357: FROM gl_period_statuses
5358: WHERE closing_status IN ('O', 'F')
5359: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5360: p_org_id)
5361: AND application_id = p_application_id