DBA Data[Home] [Help]

APPS.PO_APPROVAL_ACTION dependencies on GL_PERIOD_STATUSES

Line 560: GL_PERIOD_STATUSES PS1

556: AND Nvl(prl.modified_by_agent_flag,'N') = 'N' /*Bug 4882209*/
557: AND not exists (
558: select 'find if the GL date is not within Open period'
559: from
560: GL_PERIOD_STATUSES PS1
561: , GL_PERIOD_STATUSES PS2
562: , GL_SETS_OF_BOOKS GSOB
563: WHERE PS1.application_id = 101
564: AND PS1.set_of_books_id = FSP.set_of_books_id

Line 561: , GL_PERIOD_STATUSES PS2

557: AND not exists (
558: select 'find if the GL date is not within Open period'
559: from
560: GL_PERIOD_STATUSES PS1
561: , GL_PERIOD_STATUSES PS2
562: , GL_SETS_OF_BOOKS GSOB
563: WHERE PS1.application_id = 101
564: AND PS1.set_of_books_id = FSP.set_of_books_id
565: AND PS1.closing_status IN ('O','F')