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.

APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 1045: from gl_ledger_relationships glr1

1041:
1042: FUNCTION get_ledger_ids(p_ledger_id IN NUMBER) RETURN VARCHAR2 IS
1043: CURSOR cur_primary_ledger( p_ledger_id NUMBER) IS
1044: select distinct glr1.target_ledger_id ledger_id
1045: from gl_ledger_relationships glr1
1046: ,gl_ledger_relationships glr2
1047: where glr1.source_ledger_id = glr2.source_ledger_id
1048: and glr1.application_id = glr2.application_id
1049: and glr2.target_ledger_id = p_ledger_id

Line 1046: ,gl_ledger_relationships glr2

1042: FUNCTION get_ledger_ids(p_ledger_id IN NUMBER) RETURN VARCHAR2 IS
1043: CURSOR cur_primary_ledger( p_ledger_id NUMBER) IS
1044: select distinct glr1.target_ledger_id ledger_id
1045: from gl_ledger_relationships glr1
1046: ,gl_ledger_relationships glr2
1047: where glr1.source_ledger_id = glr2.source_ledger_id
1048: and glr1.application_id = glr2.application_id
1049: and glr2.target_ledger_id = p_ledger_id
1050: and glr2.application_id = 101

Line 1062: ,gl_ledger_relationships glr1

1058:
1059: CURSOR cur_ledger ( p_ledger_id NUMBER) IS
1060: SELECT distinct glr2.target_ledger_id ledger_id
1061: FROM gl_ledger_set_assignments gla
1062: ,gl_ledger_relationships glr1
1063: ,gl_ledger_relationships glr2
1064: WHERE gla.ledger_id = glr1.target_ledger_id
1065: AND glr1.source_ledger_id = glr2.source_ledger_id
1066: and glr1.application_id = glr2.application_id

Line 1063: ,gl_ledger_relationships glr2

1059: CURSOR cur_ledger ( p_ledger_id NUMBER) IS
1060: SELECT distinct glr2.target_ledger_id ledger_id
1061: FROM gl_ledger_set_assignments gla
1062: ,gl_ledger_relationships glr1
1063: ,gl_ledger_relationships glr2
1064: WHERE gla.ledger_id = glr1.target_ledger_id
1065: AND glr1.source_ledger_id = glr2.source_ledger_id
1066: and glr1.application_id = glr2.application_id
1067: AND gla.ledger_set_id = p_ledger_id

Line 1412: ,gl_ledger_relationships glr1

1408: FROM dual
1409: WHERE EXISTS(select 1
1410: FROM xla_events xle
1411: ,xla_transaction_entities xte
1412: ,gl_ledger_relationships glr1
1413: ,gl_ledger_relationships glr2
1414: ,xla_ledger_options xlo
1415: WHERE xle.entity_id = xte.entity_id
1416: AND xle.application_id = xte.application_id

Line 1413: ,gl_ledger_relationships glr2

1409: WHERE EXISTS(select 1
1410: FROM xla_events xle
1411: ,xla_transaction_entities xte
1412: ,gl_ledger_relationships glr1
1413: ,gl_ledger_relationships glr2
1414: ,xla_ledger_options xlo
1415: WHERE xle.entity_id = xte.entity_id
1416: AND xle.application_id = xte.application_id
1417: AND xle.event_date BETWEEN l_period_start_date and l_period_end_date

Line 1441: ,gl_ledger_relationships glr1

1437: SELECT count(*)
1438: INTO l_unprocessed
1439: FROM xla_ae_headers aeh
1440: ,xla_transaction_entities xte
1441: ,gl_ledger_relationships glr1
1442: ,gl_ledger_relationships glr2
1443: WHERE aeh.ledger_id = glr2.target_ledger_id
1444: AND glr2.source_ledger_id = glr1.source_ledger_id
1445: AND glr2.application_id = glr1.application_id

Line 1442: ,gl_ledger_relationships glr2

1438: INTO l_unprocessed
1439: FROM xla_ae_headers aeh
1440: ,xla_transaction_entities xte
1441: ,gl_ledger_relationships glr1
1442: ,gl_ledger_relationships glr2
1443: WHERE aeh.ledger_id = glr2.target_ledger_id
1444: AND glr2.source_ledger_id = glr1.source_ledger_id
1445: AND glr2.application_id = glr1.application_id
1446: AND glr1.target_ledger_id = p_ledger_id

Line 1471: ,gl_ledger_relationships glr1

1467: FROM dual
1468: WHERE EXISTS(select 1
1469: FROM xla_events xle
1470: ,xla_transaction_entities xte
1471: ,gl_ledger_relationships glr1
1472: ,gl_ledger_relationships glr2
1473: ,xla_ledger_options xlo
1474: WHERE xle.entity_id = xte.entity_id
1475: AND xle.application_id = xte.application_id

Line 1472: ,gl_ledger_relationships glr2

1468: WHERE EXISTS(select 1
1469: FROM xla_events xle
1470: ,xla_transaction_entities xte
1471: ,gl_ledger_relationships glr1
1472: ,gl_ledger_relationships glr2
1473: ,xla_ledger_options xlo
1474: WHERE xle.entity_id = xte.entity_id
1475: AND xle.application_id = xte.application_id
1476: AND xle.event_date BETWEEN l_period_start_date and l_period_end_date

Line 1505: ,gl_ledger_relationships glr1

1501: SELECT count(*)
1502: INTO l_unprocessed
1503: FROM xla_ae_headers aeh
1504: ,xla_transaction_entities xte
1505: ,gl_ledger_relationships glr1
1506: ,gl_ledger_relationships glr2
1507: WHERE aeh.ledger_id = glr2.target_ledger_id
1508: AND glr2.source_ledger_id = glr1.source_ledger_id
1509: AND glr2.application_id = glr1.application_id

Line 1506: ,gl_ledger_relationships glr2

1502: INTO l_unprocessed
1503: FROM xla_ae_headers aeh
1504: ,xla_transaction_entities xte
1505: ,gl_ledger_relationships glr1
1506: ,gl_ledger_relationships glr2
1507: WHERE aeh.ledger_id = glr2.target_ledger_id
1508: AND glr2.source_ledger_id = glr1.source_ledger_id
1509: AND glr2.application_id = glr1.application_id
1510: AND glr1.target_ledger_id = p_ledger_id