APPS.XLA_REPORTING_SEQUENCE_PKG dependencies on GL_LEDGER_NORM_SEG_VALS

Line 1254: ,gl_ledger_norm_seg_vals glnsv

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

Line 1329: ,gl_ledger_norm_seg_vals glnsv

1325: AND gps.ledger_id = p_ledger_id
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'

Line 1390: ,gl_ledger_norm_seg_vals glnsv

1386: AND gps.ledger_id = p_ledger_id
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'

Line 1447: ,gl_ledger_norm_seg_vals glnsv

1443: AND gps.ledger_id = p_ledger_id
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'

Line 1498: ,gl_ledger_norm_seg_vals glnsv

1494: AND xah.balance_type_code = 'A'
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'

Line 1546: ,gl_ledger_norm_seg_vals glnsv

1542: AND xah.balance_type_code = 'A'
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'

Line 1595: ,gl_ledger_norm_seg_vals glnsv

1591: AND xah.balance_type_code = 'A'
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'