APPS.ARP_VIEW_CONSTANTS dependencies on GL_PERIOD_STATUSES

Line 120: from gl_period_statuses

116: select decode(max(period_name),
117: '', 0,
118: 1)
119: into num_return_value
120: from gl_period_statuses
121: where application_id = p_application_id
122: and set_of_books_id = p_set_of_books_id
123: and adjustment_period_flag = 'N'
124: and l_gl_date between start_date and end_date

Line 131: from gl_period_statuses

127: select decode(max(period_name),
128: '', 0,
129: 1)
130: into num_return_value
131: from gl_period_statuses
132: where application_id = p_application_id
133: and set_of_books_id = p_set_of_books_id
134: and adjustment_period_flag = 'N'
135: and l_gl_date between start_date and end_date

Line 313: from gl_period_statuses d,

309:
310:
311: select max(d.end_date)
312: into candidate_gl_date
313: from gl_period_statuses d,
314: gl_period_statuses s
315: where d.application_id = s.application_id
316: and d.set_of_books_id = s.set_of_books_id
317: and d.adjustment_period_flag = 'N'

Line 314: gl_period_statuses s

310:
311: select max(d.end_date)
312: into candidate_gl_date
313: from gl_period_statuses d,
314: gl_period_statuses s
315: where d.application_id = s.application_id
316: and d.set_of_books_id = s.set_of_books_id
317: and d.adjustment_period_flag = 'N'
318: and d.end_date < sysdate

Line 382: from gl_period_statuses

378: /* Try first Open period after trx_date */
379:
380: select min(start_date)
381: into candidate_gl_date
382: from gl_period_statuses
383: where application_id = h_application_id
384: and set_of_books_id = h_set_of_books_id
385: and adjustment_period_flag = 'N'
386: and closing_status = 'O'

Line 412: from gl_period_statuses

408: /* Try first Future period after trx_date */
409:
410: select min(start_date)
411: into candidate_gl_date
412: from gl_period_statuses
413: where application_id = h_application_id
414: and set_of_books_id = h_set_of_books_id
415: and adjustment_period_flag = 'N'
416: and closing_status = 'F'

Line 443: from gl_period_statuses

439: /* try the first open period after sysdate */
440:
441: select max(start_date)
442: into candidate_gl_date
443: from gl_period_statuses
444: where application_id = h_application_id
445: and set_of_books_id = h_set_of_books_id
446: and adjustment_period_flag = 'N'
447: and closing_status = 'O'

Line 474: from gl_period_statuses

470:
471: select max(start_date), max(end_date)
472: into candidate_start_gl_date,
473: candidate_end_gl_date
474: from gl_period_statuses
475: where application_id = h_application_id
476: and set_of_books_id = h_set_of_books_id
477: and adjustment_period_flag = 'N'
478: and closing_status = 'O';

Line 508: from gl_period_statuses

504: /* try the first Future period >= sysdate */
505:
506: select min(start_date)
507: into candidate_gl_date
508: from gl_period_statuses
509: where application_id = h_application_id
510: and set_of_books_id = h_set_of_books_id
511: and adjustment_period_flag = 'N'
512: and closing_status = 'F'

Line 540: from gl_period_statuses

536:
537: select max(start_date), max(end_date)
538: into candidate_start_gl_date,
539: candidate_end_gl_date
540: from gl_period_statuses
541: where application_id = h_application_id
542: and set_of_books_id = h_set_of_books_id
543: and adjustment_period_flag = 'N'
544: and closing_status = 'F';