APPS.XLA_REPORTING_SEQUENCE_PKG dependencies on GL_LEDGER_SEGMENT_VALUES

Line 1253: FROM gl_ledger_segment_values glsv

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

Line 1328: FROM gl_ledger_segment_values glsv

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

Line 1389: FROM gl_ledger_segment_values glsv

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

Line 1446: FROM gl_ledger_segment_values glsv

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

Line 1497: FROM gl_ledger_segment_values glsv

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

Line 1545: FROM gl_ledger_segment_values glsv

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

Line 1594: FROM gl_ledger_segment_values glsv

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