1495: AND exists
1496: (SELECT 1
1497: FROM gl_ledger_segment_values glsv
1498: ,gl_ledger_norm_seg_vals glnsv
1499: ,xla_ae_segment_values xasv
1500: WHERE xah.ae_header_id = xasv.ae_header_id
1501: AND glsv.ledger_id (+) = p_ledger_id
1502: AND xasv.segment_type_code = 'B'
1503: AND xasv.segment_type_code = glsv.segment_type_code (+)
1543: AND exists
1544: (SELECT 1
1545: FROM gl_ledger_segment_values glsv
1546: ,gl_ledger_norm_seg_vals glnsv
1547: ,xla_ae_segment_values xasv
1548: WHERE xah.ae_header_id = xasv.ae_header_id
1549: AND glsv.ledger_id (+) = p_ledger_id
1550: AND xasv.segment_type_code = 'B'
1551: AND xasv.segment_type_code = glsv.segment_type_code (+)
1592: AND exists
1593: (SELECT 1
1594: FROM gl_ledger_segment_values glsv
1595: ,gl_ledger_norm_seg_vals glnsv
1596: ,xla_ae_segment_values xasv
1597: WHERE xah.ae_header_id = xasv.ae_header_id
1598: AND glsv.ledger_id (+) = p_ledger_id
1599: AND xasv.segment_type_code = 'B'
1600: AND xasv.segment_type_code = glsv.segment_type_code (+)