APPS.FV_SLA_PROCESSING_PKG dependencies on GL_LEDGERS

Line 616: FROM gl_ledgers

612: WHERE set_of_books_id = p_ledger_id;
613:
614: CURSOR c_currency_code IS
615: SELECT currency_code
616: FROM gl_ledgers
617: WHERE ledger_id = p_Ledger_id;
618:
619: CURSOR c_period (c_ledger_id NUMBER,
620: c_period_name VARCHAR2) IS

Line 1609: FROM xla_events_gt xgt ,gl_ledgers gl

1605:
1606:
1607: CURSOR c_ledger_info( p_event_id NUMBER ) IS
1608: SELECT chart_of_accounts_id coaid, gl.Ledger_id ledger_id
1609: FROM xla_events_gt xgt ,gl_ledgers gl
1610: WHERE gl.ledger_id = xgt.ledger_id
1611: AND xgt.application_id = p_application_id
1612: AND xgt.event_id = p_event_id;
1613:

Line 2147: FROM xla_events_gt xgt ,gl_ledgers gl

2143: l_procedure_name VARCHAR2(100):='.CST_EXTRACT';
2144:
2145: CURSOR c_ledger_info( p_event_id NUMBER ) IS
2146: SELECT chart_of_accounts_id coaid, gl.Ledger_id ledger_id
2147: FROM xla_events_gt xgt ,gl_ledgers gl
2148: WHERE gl.ledger_id = xgt.ledger_id
2149: AND xgt.application_id = p_application_id
2150: AND xgt.event_id = p_event_id;
2151:

Line 2453: FROM xla_events_gt xgt ,gl_ledgers gl

2449: l_procedure_name VARCHAR2(100):='.AP_EXTRACT';
2450:
2451: CURSOR c_ledger_info( p_event_id NUMBER ) IS
2452: SELECT chart_of_accounts_id coaid, gl.Ledger_id ledger_id
2453: FROM xla_events_gt xgt ,gl_ledgers gl
2454: WHERE gl.ledger_id = xgt.ledger_id
2455: AND xgt.application_id = p_application_id
2456: AND xgt.event_id = p_event_id;
2457: