APPS.AP_WEB_EXPORT_ER dependencies on GL_PERIOD_STATUSES

Line 34: FROM gl_period_statuses

30: BEGIN
31:
32: SELECT closing_status
33: INTO l_gl_period_status
34: FROM gl_period_statuses
35: WHERE application_id=200
36: AND set_of_books_id= p_set_of_books_id
37: AND to_date(p_source_date,'DD-MM-RRRR') BETWEEN start_date AND end_date
38: AND NVL(adjustment_period_flag, 'N') = 'N';

Line 93: FROM gl_period_statuses

89: BEGIN
90:
91: SELECT min(start_date)
92: INTO l_new_gl_date
93: FROM gl_period_statuses
94: WHERE application_id = 200
95: AND set_of_books_id = p_set_of_books_id
96: AND start_date > to_date(p_source_date,'DD-MM-RRRR')
97: AND (closing_status in ('O', 'F'))