DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on GL_LEDGERS

Line 49: FROM gl_ledgers GLL

45: /* Query to get the ledger Id */
46: BEGIN
47: SELECT GLL.ledger_id
48: INTO gn_ledger_id
49: FROM gl_ledgers GLL
50: ,gl_access_set_norm_assign GASNA
51: WHERE GASNA.access_set_id = FND_PROFILE.VALUE('GL_ACCESS_SET_ID')
52: AND GLL.ledger_id = GASNA.ledger_id
53: AND GLL.ledger_category_code = 'PRIMARY';

Line 60: ,gl_ledgers GLL

56: BEGIN
57: SELECT GLP.start_date
58: INTO gc_per_start_date
59: FROM gl_periods GLP
60: ,gl_ledgers GLL
61: WHERE GLL.ledger_id = gn_ledger_id
62: AND GLP.period_set_name = GLL.period_set_name
63: AND GLP.period_name = P_PERIOD_FROM;
64: END;

Line 70: ,gl_ledgers GLL

66: BEGIN
67: SELECT GLP.end_date
68: INTO gc_per_end_date
69: FROM gl_periods GLP
70: ,gl_ledgers GLL
71: WHERE GLL.ledger_id = gn_ledger_id
72: AND GLP.period_set_name = GLL.period_set_name
73: AND GLP.period_name = P_PERIOD_TO;
74: END;