APPS.XLA_TP_SUMMARY_RPT_PKG dependencies on GL_LEDGERS

Line 59: ,gl_ledgers GLL

55: TO_DATE(TO_CHAR(GP.end_date,'DD-MON-YYYY')
56: ||' 23:59:59','DD-MM-YYYY HH24:MI:SS') END)
57: INTO P_PERIOD_START_DATE,P_PERIOD_END_DATE
58: FROM gl_periods GP
59: ,gl_ledgers GLL
60: WHERE GLL.ledger_id=P_LEDGER_ID
61: AND GP.period_set_name =GLL.period_set_name
62: AND GP.period_name IN (P_PERIOD_FROM,P_PERIOD_TO);
63: END;

Line 68: FROM gl_ledgers_public_v

64: /* Query to select the ledger name and the ledger currency.*/
65: BEGIN
66: SELECT currency_code
67: INTO P_LEDGER_CURRENCY
68: FROM gl_ledgers_public_v
69: WHERE ledger_id=P_LEDGER_ID;
70: END;
71: /* Query to fetch the Effective period number from */
72: BEGIN