DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on GL_PERIOD_STATUSES

Line 1148: FROM gl_period_statuses

1144: BEGIN
1145:
1146: SELECT closing_status
1147: INTO l_gl_period_status
1148: FROM gl_period_statuses
1149: WHERE application_id=200
1150: AND set_of_books_id= p_set_of_books_id
1151: AND trunc(p_source_date) BETWEEN start_date AND end_date
1152: AND NVL(adjustment_period_flag, 'N') = 'N';

Line 1207: FROM gl_period_statuses

1203: BEGIN
1204:
1205: SELECT min(start_date)
1206: INTO l_new_gl_date
1207: FROM gl_period_statuses
1208: WHERE application_id = 200
1209: AND set_of_books_id = p_set_of_books_id
1210: AND start_date > trunc(p_source_date)
1211: AND (closing_status in ('O', 'F'))