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';
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;
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;