APPS.XLA_REPORTING_SEQUENCE_PKG dependencies on GL_LEDGER_SEGMENT_VALUES

Line 1251: FROM gl_ledger_segment_values glsv

1247: -- otherwise, all the segments are balancing segments.
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'

Line 1326: FROM gl_ledger_segment_values glsv

1322: AND gjh.period_name = gps.period_name
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

Line 1387: FROM gl_ledger_segment_values glsv

1383: AND gjh.period_name = gps.period_name
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

Line 1444: FROM gl_ledger_segment_values glsv

1440: AND gjh.period_name = gps.period_name
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

Line 1495: FROM gl_ledger_segment_values glsv

1491: AND xah.application_id = xs.application_id
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

Line 1543: FROM gl_ledger_segment_values glsv

1539: AND xah.application_id = xs.application_id
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

Line 1592: FROM gl_ledger_segment_values glsv

1588: AND xah.application_id = xs.application_id
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