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