DBA Data[Home] [Help]

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on GL_LEDGER_NORM_SEG_VALS

Line 414: FROM GL_LEDGER_NORM_SEG_VALS

410: BEGIN
411:
412: SELECT COUNT(segment_value)
413: INTO l_bsv_count
414: FROM GL_LEDGER_NORM_SEG_VALS
415: WHERE ledger_id = g_ledger_id
416: AND legal_entity_id = g_legal_entity_id
417: AND segment_type_code = 'B';
418:

Line 456: FROM GL_LEDGER_NORM_SEG_VALS

452: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,
453: jg_info_v1)
454: SELECT g_concurrent_request_id,
455: segment_value
456: FROM GL_LEDGER_NORM_SEG_VALS
457: WHERE ledger_id = g_ledger_id
458: AND legal_entity_id = g_legal_entity_id
459: AND segment_type_code = 'B'
460: AND g_establishment_id is null -- IF running in Centralized mode and only for LE