DBA Data[Home] [Help]

APPS.JA_CN_SM_EXPORT_PKG dependencies on GL_PERIOD_STATUSES

Line 104: FROM GL_PERIOD_STATUSES gps

100: AND jcvn.je_header_id = jl.je_header_id ----Add these two conditions
101: AND jcvn.je_line_number = jl.je_line_num
102: AND jl.period_name IN
103: (SELECT gps.period_name
104: FROM GL_PERIOD_STATUSES gps
105: WHERE gps.ledger_id = jl.ledger_id
106: AND gps.application_id = 101
107: and gps.period_year = pv_accounting_year))
108: ORDER BY Settlement_Method_Number;