APPS.PO_DOCUMENT_CONTROL_PVT dependencies on GL_PERIOD_STATUSES

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

3776: RETURN BOOLEAN
3777: IS
3778:
3779: CURSOR l_gl_period_csr IS
3780: -- SQL What: Querying GL_PERIOD_STATUSES and FINANCIALS_SYSTEM_PARAMETERS
3781: -- SQL Why: Check if p_date is in an open GL period
3782: -- SQL Join: set_of_books_id, period_name
3783: SELECT 'In open GL period'
3784: FROM gl_period_statuses gl_ps,

Line 3784: FROM gl_period_statuses gl_ps,

3780: -- SQL What: Querying GL_PERIOD_STATUSES and FINANCIALS_SYSTEM_PARAMETERS
3781: -- SQL Why: Check if p_date is in an open GL period
3782: -- SQL Join: set_of_books_id, period_name
3783: SELECT 'In open GL period'
3784: FROM gl_period_statuses gl_ps,
3785: gl_period_statuses po_ps,
3786: financials_system_parameters fsp
3787: WHERE gl_ps.application_id = 101 AND
3788: gl_ps.set_of_books_id = fsp.set_of_books_id AND

Line 3785: gl_period_statuses po_ps,

3781: -- SQL Why: Check if p_date is in an open GL period
3782: -- SQL Join: set_of_books_id, period_name
3783: SELECT 'In open GL period'
3784: FROM gl_period_statuses gl_ps,
3785: gl_period_statuses po_ps,
3786: financials_system_parameters fsp
3787: WHERE gl_ps.application_id = 101 AND
3788: gl_ps.set_of_books_id = fsp.set_of_books_id AND
3789: gl_ps.closing_status IN ('O','F') AND