APPS.XLA_REPORTING_SEQUENCE_PKG dependencies on GL_LEDGER_NORM_SEG_VALS

Line 1252: ,gl_ledger_norm_seg_vals glnsv

1248:
1249: cursor c_analytical_segment_defined(l_ledger_id NUMBER) is
1250: SELECT 1
1251: FROM gl_ledger_segment_values glsv
1252: ,gl_ledger_norm_seg_vals glnsv
1253: WHERE
1254: glsv.ledger_id = l_ledger_id
1255: AND glsv.segment_type_code = 'B'
1256: AND glsv.parent_record_id = glnsv.record_id

Line 1327: ,gl_ledger_norm_seg_vals glnsv

1323: AND gps.ledger_id = p_ledger_id
1324: AND exists
1325: (SELECT 1
1326: FROM gl_ledger_segment_values glsv
1327: ,gl_ledger_norm_seg_vals glnsv
1328: ,gl_je_segment_values gljsv
1329: WHERE gljsv.je_header_id = gjh.je_header_id
1330: AND glsv.ledger_id (+) = p_ledger_id
1331: AND gljsv.segment_type_code = 'B'

Line 1388: ,gl_ledger_norm_seg_vals glnsv

1384: AND gps.ledger_id = p_ledger_id
1385: AND exists
1386: (SELECT 1
1387: FROM gl_ledger_segment_values glsv
1388: ,gl_ledger_norm_seg_vals glnsv
1389: ,gl_je_segment_values gljsv
1390: WHERE gljsv.je_header_id = gjh.je_header_id
1391: AND glsv.ledger_id (+) = p_ledger_id
1392: AND gljsv.segment_type_code = 'B'

Line 1445: ,gl_ledger_norm_seg_vals glnsv

1441: AND gps.ledger_id = p_ledger_id
1442: AND exists
1443: (SELECT 1
1444: FROM gl_ledger_segment_values glsv
1445: ,gl_ledger_norm_seg_vals glnsv
1446: ,gl_je_segment_values gljsv
1447: WHERE gljsv.je_header_id = gjh.je_header_id
1448: AND glsv.ledger_id (+) = p_ledger_id
1449: AND gljsv.segment_type_code = 'B'

Line 1496: ,gl_ledger_norm_seg_vals glnsv

1492: AND xah.balance_type_code = 'A'
1493: AND exists
1494: (SELECT 1
1495: FROM gl_ledger_segment_values glsv
1496: ,gl_ledger_norm_seg_vals glnsv
1497: ,xla_ae_segment_values xasv
1498: WHERE xah.ae_header_id = xasv.ae_header_id
1499: AND glsv.ledger_id (+) = p_ledger_id
1500: AND xasv.segment_type_code = 'B'

Line 1544: ,gl_ledger_norm_seg_vals glnsv

1540: AND xah.balance_type_code = 'A'
1541: AND exists
1542: (SELECT 1
1543: FROM gl_ledger_segment_values glsv
1544: ,gl_ledger_norm_seg_vals glnsv
1545: ,xla_ae_segment_values xasv
1546: WHERE xah.ae_header_id = xasv.ae_header_id
1547: AND glsv.ledger_id (+) = p_ledger_id
1548: AND xasv.segment_type_code = 'B'

Line 1593: ,gl_ledger_norm_seg_vals glnsv

1589: AND xah.balance_type_code = 'A'
1590: AND exists
1591: (SELECT 1
1592: FROM gl_ledger_segment_values glsv
1593: ,gl_ledger_norm_seg_vals glnsv
1594: ,xla_ae_segment_values xasv
1595: WHERE xah.ae_header_id = xasv.ae_header_id
1596: AND glsv.ledger_id (+) = p_ledger_id
1597: AND xasv.segment_type_code = 'B'