80: AND JEH.actual_flag <> 'B'
81: AND JEH.reversed_je_header_id IS NULL
82: AND EXISTS
83: (SELECT 1
84: FROM GL_LEDGER_RELATIONSHIPS LRL
85: WHERE LRL.source_ledger_id = abs(JEH.ledger_id)
86: AND LRL.target_ledger_category_code = 'ALC'
87: AND LRL.relationship_type_code IN ('JOURNAL', 'SUBLEDGER')
88: AND LRL.application_id = 101