DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CONTROL_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 3638: -- SQL What: Querying GL_PERIOD_STATUSES and FINANCIALS_SYSTEM_PARAMETERS

3634: -- bug 5498063
3635: l_validate_gl_period VARCHAR2(1);
3636:
3637: CURSOR l_gl_period_csr IS
3638: -- SQL What: Querying GL_PERIOD_STATUSES and FINANCIALS_SYSTEM_PARAMETERS
3639: -- SQL Why: Check if p_date is in an open GL period
3640: -- SQL Join: set_of_books_id, period_name
3641: SELECT 'In open GL period'
3642: FROM gl_period_statuses gl_ps,

Line 3644: financials_system_parameters fsp

3640: -- SQL Join: set_of_books_id, period_name
3641: SELECT 'In open GL period'
3642: FROM gl_period_statuses gl_ps,
3643: gl_period_statuses po_ps,
3644: financials_system_parameters fsp
3645: WHERE gl_ps.application_id = 101 AND
3646: gl_ps.set_of_books_id = fsp.set_of_books_id AND
3647: -- bug 5498063
3648: (( (l_validate_gl_period = 'Y' OR l_validate_gl_period = 'R')--Bug15874392