DBA Data[Home] [Help]

APPS.IGIPMGLT dependencies on GL_PERIOD_STATUSES

Line 310: from gl_period_statuses

306: l_glint_control GLINT_CONTROL;
307:
308: CURSOR c_start_date IS
309: SELECT start_date
310: from gl_period_statuses
311: where set_of_books_id = p_set_of_books_id
312: and application_id = 200
313: and adjustment_period_flag = 'N'
314: and effective_period_num = p_start_period_eff_num

Line 318: from gl_period_statuses

314: and effective_period_num = p_start_period_eff_num
315: ;
316: CURSOR c_end_date IS
317: SELECT end_date
318: from gl_period_statuses
319: where set_of_books_id = p_set_of_books_id
320: and application_id = 200
321: and adjustment_period_flag = 'N'
322: and effective_period_num = p_end_period_eff_num

Line 327: from gl_period_statuses

323: ;
324:
325: CURSOR c_periods IS
326: SELECT period_name, set_of_books_id
327: from gl_period_statuses
328: where set_of_books_id = p_set_of_books_id
329: and application_id = 200
330: and adjustment_period_flag = 'N'
331: and effective_period_num between p_start_period_eff_num and