DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on GL_PERIODS

Line 60: FROM gl_periods GLP

56: /*Query to get the Start date for a given Period From parameter */
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;

Line 70: FROM gl_periods GLP

66: /*Query to get the End date for a given Period To parameter */
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;