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