DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on GL_LEDGERS

Line 50: FROM gl_ledgers GLL

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

Line 61: ,gl_ledgers GLL

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

Line 71: ,gl_ledgers GLL

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