1326: AND exists
1327: (SELECT 1
1328: FROM gl_ledger_segment_values glsv
1329: ,gl_ledger_norm_seg_vals glnsv
1330: ,gl_je_segment_values gljsv
1331: WHERE gljsv.je_header_id = gjh.je_header_id
1332: AND glsv.ledger_id (+) = p_ledger_id
1333: AND gljsv.segment_type_code = 'B'
1334: AND gljsv.segment_type_code = glsv.segment_type_code (+)
1387: AND exists
1388: (SELECT 1
1389: FROM gl_ledger_segment_values glsv
1390: ,gl_ledger_norm_seg_vals glnsv
1391: ,gl_je_segment_values gljsv
1392: WHERE gljsv.je_header_id = gjh.je_header_id
1393: AND glsv.ledger_id (+) = p_ledger_id
1394: AND gljsv.segment_type_code = 'B'
1395: AND gljsv.segment_type_code = glsv.segment_type_code (+)
1444: AND exists
1445: (SELECT 1
1446: FROM gl_ledger_segment_values glsv
1447: ,gl_ledger_norm_seg_vals glnsv
1448: ,gl_je_segment_values gljsv
1449: WHERE gljsv.je_header_id = gjh.je_header_id
1450: AND glsv.ledger_id (+) = p_ledger_id
1451: AND gljsv.segment_type_code = 'B'
1452: AND gljsv.segment_type_code = glsv.segment_type_code (+)