DBA Data[Home] [Help]

APPS.GL_AFF_AWC_API_PKG dependencies on GL_LEDGERS

Line 199: To avoid multiple SQL checks GL_LEDGERS table is

195: IF bal_seg_value_option_code column value in GL_LEDGER table is
196: 'A' that means all BSV's are valid. If the column is 'I',
197: then some BSV's are valid.
198:
199: To avoid multiple SQL checks GL_LEDGERS table is
200: joined to gl_ledger_segment_values table.
201: */
202:
203: SELECT DECODE(NVL(gll.bal_seg_value_option_code, 'X'),

Line 208: FROM gl_ledger_segment_values glsv, gl_ledgers gll

204: 'I',
205: DECODE(glsv.segment_value, NULL, 'N',p_flex_value,'Y', 'N'),
206: 'Y')
207: INTO l_valid_value
208: FROM gl_ledger_segment_values glsv, gl_ledgers gll
209: WHERE gll.ledger_id = l_lgr_id
210: AND gll.ledger_id = glsv.ledger_id (+)
211: AND glsv.segment_type_code (+) = 'B'
212: AND NVL(glsv.status_code (+), 'X') <> 'I'