598: AND Nvl(prl.modified_by_agent_flag,'N') = 'N' /*Bug 4882209*/
599: AND not exists (
600: select 'find if the GL date is not within Open period'
601: from
602: GL_PERIOD_STATUSES PS1
603: , GL_PERIOD_STATUSES PS2
604: , GL_SETS_OF_BOOKS GSOB
605: WHERE PS1.application_id = 101
606: AND PS1.set_of_books_id = FSP.set_of_books_id
599: AND not exists (
600: select 'find if the GL date is not within Open period'
601: from
602: GL_PERIOD_STATUSES PS1
603: , GL_PERIOD_STATUSES PS2
604: , GL_SETS_OF_BOOKS GSOB
605: WHERE PS1.application_id = 101
606: AND PS1.set_of_books_id = FSP.set_of_books_id
607: -- bug 5498063