APPS.PO_PERIODS_SV dependencies on GL_SETS_OF_BOOKS

Line 203: GL_SETS_OF_BOOKS SOB

199: GL_PS.period_num,
200: GL_PS.quarter_num
201: FROM GL_PERIOD_STATUSES GL_PS,
202: GL_PERIOD_STATUSES PO_PS,
203: GL_SETS_OF_BOOKS SOB
204: WHERE SOB.set_of_books_id = l_set_of_books_id
205: AND GL_PS.application_id = 101
206: AND PO_PS.application_id = 201
207: AND GL_PS.set_of_books_id = SOB.set_of_books_id --JOIN

Line 483: GL_SETS_OF_BOOKS SOB

479: SELECT GL_PS.period_name
480: into x_gl_period
481: FROM GL_PERIOD_STATUSES GL_PS,
482: GL_PERIOD_STATUSES PO_PS,
483: GL_SETS_OF_BOOKS SOB
484: WHERE SOB.set_of_books_id = l_sob_id
485: AND GL_PS.application_id = 101
486: AND PO_PS.application_id = 201
487: AND GL_PS.set_of_books_id = SOB.set_of_books_id --JOIN

Line 509: GL_SETS_OF_BOOKS SOB

505: SELECT GL_PS.period_name
506: into x_gl_period
507: FROM GL_PERIOD_STATUSES GL_PS,
508: GL_PERIOD_STATUSES PO_PS,
509: GL_SETS_OF_BOOKS SOB
510: WHERE SOB.set_of_books_id = l_sob_id
511: AND GL_PS.application_id = 101
512: AND PO_PS.application_id = 201
513: AND GL_PS.set_of_books_id = SOB.set_of_books_id --JOIN

Line 549: GL_SETS_OF_BOOKS SOB

545: gl_ps.period_name latest_period_name,
546: TRUNC(GL_PS.start_date) latest_open_date
547: FROM GL_PERIOD_STATUSES GL_PS,
548: GL_PERIOD_STATUSES PO_PS,
549: GL_SETS_OF_BOOKS SOB
550: WHERE SOB.set_of_books_id = l_sob_id
551: AND GL_PS.application_id = 101
552: AND PO_PS.application_id = 201
553: AND GL_PS.set_of_books_id = SOB.set_of_books_id --JOIN

Line 596: GL_SETS_OF_BOOKS SOB

592: gl_ps.period_name latest_period_name,
593: TRUNC(GL_PS.start_date) latest_open_date
594: FROM GL_PERIOD_STATUSES GL_PS,
595: GL_PERIOD_STATUSES PO_PS,
596: GL_SETS_OF_BOOKS SOB
597: WHERE SOB.set_of_books_id = l_sob_id
598: AND GL_PS.application_id = 101
599: AND PO_PS.application_id = 201
600: AND GL_PS.set_of_books_id = SOB.set_of_books_id --JOIN