eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 1096: from gl_ledger_relationships glr1

1092:
1093: FUNCTION get_ledger_ids(p_ledger_id IN NUMBER) RETURN VARCHAR2 IS
1094: CURSOR cur_primary_ledger( p_ledger_id NUMBER) IS
1095: select distinct glr1.target_ledger_id ledger_id
1096: from gl_ledger_relationships glr1
1097: ,gl_ledger_relationships glr2
1098: where glr1.source_ledger_id = glr2.source_ledger_id
1099: and glr1.application_id = glr2.application_id
1100: and glr2.target_ledger_id = p_ledger_id

Line 1097: ,gl_ledger_relationships glr2

1093: FUNCTION get_ledger_ids(p_ledger_id IN NUMBER) RETURN VARCHAR2 IS
1094: CURSOR cur_primary_ledger( p_ledger_id NUMBER) IS
1095: select distinct glr1.target_ledger_id ledger_id
1096: from gl_ledger_relationships glr1
1097: ,gl_ledger_relationships glr2
1098: where glr1.source_ledger_id = glr2.source_ledger_id
1099: and glr1.application_id = glr2.application_id
1100: and glr2.target_ledger_id = p_ledger_id
1101: and glr2.application_id = 101

Line 1113: ,gl_ledger_relationships glr1

1109:
1110: CURSOR cur_ledger ( p_ledger_id NUMBER) IS
1111: SELECT distinct glr2.target_ledger_id ledger_id
1112: FROM gl_ledger_set_assignments gla
1113: ,gl_ledger_relationships glr1
1114: ,gl_ledger_relationships glr2
1115: WHERE gla.ledger_id = glr1.target_ledger_id
1116: AND glr1.source_ledger_id = glr2.source_ledger_id
1117: and glr1.application_id = glr2.application_id

Line 1114: ,gl_ledger_relationships glr2

1110: CURSOR cur_ledger ( p_ledger_id NUMBER) IS
1111: SELECT distinct glr2.target_ledger_id ledger_id
1112: FROM gl_ledger_set_assignments gla
1113: ,gl_ledger_relationships glr1
1114: ,gl_ledger_relationships glr2
1115: WHERE gla.ledger_id = glr1.target_ledger_id
1116: AND glr1.source_ledger_id = glr2.source_ledger_id
1117: and glr1.application_id = glr2.application_id
1118: AND gla.ledger_set_id = p_ledger_id

Line 1463: ,gl_ledger_relationships glr1

1459: FROM dual
1460: WHERE EXISTS(select 1
1461: FROM xla_events xle
1462: ,xla_transaction_entities xte
1463: ,gl_ledger_relationships glr1
1464: ,gl_ledger_relationships glr2
1465: ,xla_ledger_options xlo
1466: WHERE xle.entity_id = xte.entity_id
1467: AND xle.application_id = xte.application_id

Line 1464: ,gl_ledger_relationships glr2

1460: WHERE EXISTS(select 1
1461: FROM xla_events xle
1462: ,xla_transaction_entities xte
1463: ,gl_ledger_relationships glr1
1464: ,gl_ledger_relationships glr2
1465: ,xla_ledger_options xlo
1466: WHERE xle.entity_id = xte.entity_id
1467: AND xle.application_id = xte.application_id
1468: AND xle.event_date BETWEEN l_period_start_date and l_period_end_date

Line 1492: ,gl_ledger_relationships glr1

1488: SELECT count(*)
1489: INTO l_unprocessed
1490: FROM xla_ae_headers aeh
1491: ,xla_transaction_entities xte
1492: ,gl_ledger_relationships glr1
1493: ,gl_ledger_relationships glr2
1494: WHERE aeh.ledger_id = glr2.target_ledger_id
1495: AND glr2.source_ledger_id = glr1.source_ledger_id
1496: AND glr2.application_id = glr1.application_id

Line 1493: ,gl_ledger_relationships glr2

1489: INTO l_unprocessed
1490: FROM xla_ae_headers aeh
1491: ,xla_transaction_entities xte
1492: ,gl_ledger_relationships glr1
1493: ,gl_ledger_relationships glr2
1494: WHERE aeh.ledger_id = glr2.target_ledger_id
1495: AND glr2.source_ledger_id = glr1.source_ledger_id
1496: AND glr2.application_id = glr1.application_id
1497: AND glr1.target_ledger_id = p_ledger_id

Line 1522: ,gl_ledger_relationships glr1

1518: FROM dual
1519: WHERE EXISTS(select 1
1520: FROM xla_events xle
1521: ,xla_transaction_entities xte
1522: ,gl_ledger_relationships glr1
1523: ,gl_ledger_relationships glr2
1524: ,xla_ledger_options xlo
1525: WHERE xle.entity_id = xte.entity_id
1526: AND xle.application_id = xte.application_id

Line 1523: ,gl_ledger_relationships glr2

1519: WHERE EXISTS(select 1
1520: FROM xla_events xle
1521: ,xla_transaction_entities xte
1522: ,gl_ledger_relationships glr1
1523: ,gl_ledger_relationships glr2
1524: ,xla_ledger_options xlo
1525: WHERE xle.entity_id = xte.entity_id
1526: AND xle.application_id = xte.application_id
1527: AND xle.event_date BETWEEN l_period_start_date and l_period_end_date

Line 1556: ,gl_ledger_relationships glr1

1552: SELECT count(*)
1553: INTO l_unprocessed
1554: FROM xla_ae_headers aeh
1555: ,xla_transaction_entities xte
1556: ,gl_ledger_relationships glr1
1557: ,gl_ledger_relationships glr2
1558: WHERE aeh.ledger_id = glr2.target_ledger_id
1559: AND glr2.source_ledger_id = glr1.source_ledger_id
1560: AND glr2.application_id = glr1.application_id

Line 1557: ,gl_ledger_relationships glr2

1553: INTO l_unprocessed
1554: FROM xla_ae_headers aeh
1555: ,xla_transaction_entities xte
1556: ,gl_ledger_relationships glr1
1557: ,gl_ledger_relationships glr2
1558: WHERE aeh.ledger_id = glr2.target_ledger_id
1559: AND glr2.source_ledger_id = glr1.source_ledger_id
1560: AND glr2.application_id = glr1.application_id
1561: AND glr1.target_ledger_id = p_ledger_id