APPS.PNP_UTIL_FUNC dependencies on GL_PERIOD_STATUSES

Line 5477: l_gl_period_name gl_period_statuses.period_name%TYPE;

5473: p_application_id IN NUMBER,
5474: p_org_id IN NUMBER
5475: ) RETURN VARCHAR2 IS
5476:
5477: l_gl_period_name gl_period_statuses.period_name%TYPE;
5478: l_err_msg VARCHAR2(2000);
5479:
5480: BEGIN
5481:

Line 5487: FROM gl_period_statuses

5483: AND end date of an open GL period. */
5484:
5485: SELECT period_name
5486: INTO l_gl_period_name
5487: FROM gl_period_statuses
5488: WHERE closing_status IN ('O', 'F')
5489: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5490: p_org_id)
5491: AND application_id = p_application_id

Line 5508: FROM gl_period_statuses

5504: next open GL period name is seleted. */
5505:
5506: SELECT period_name
5507: INTO l_gl_period_name
5508: FROM gl_period_statuses
5509: WHERE closing_status IN ('O', 'F')
5510: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5511: p_org_id)
5512: AND application_id = p_application_id

Line 5515: FROM gl_period_statuses

5511: p_org_id)
5512: AND application_id = p_application_id
5513: AND adjustment_period_flag = 'N'
5514: AND start_date = (SELECT MIN(start_date)
5515: FROM gl_period_statuses
5516: WHERE closing_status IN ('O', 'F')
5517: AND set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
5518: p_org_id)
5519: AND application_id = p_application_id