DBA Data[Home] [Help]

APPS.JA_CN_PS_SI_SM_EXPORT_PKG dependencies on GL_PERIOD_STATUSES

Line 87: FROM gl_period_statuses gps

83: AND jcvn.je_line_number = jl.je_line_num
84: AND jl.ledger_id = pn_ledger -- Ledger ID Parameter
85: AND jl.period_name IN
86: (SELECT gps.period_name
87: FROM gl_period_statuses gps
88: WHERE gps.ledger_id = jl.ledger_id
89: AND gps.application_id = 101
90: AND gps.period_year = pn_account_year --Accounting Year parameter
91: ))