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';
55: END;
56: /*Query to get the Start date for a given Period From parameter */
109: AND FSEG.flex_value_set_id = FFV.flex_value_set_id
110: AND FFS.id_flex_code = 'GL#'
111: AND GCC.chart_of_accounts_id = (SELECT GAS.chart_of_accounts_id
112: FROM gl_access_sets GAS
113: WHERE GAS.access_set_id = FND_PROFILE.value('GL_ACCESS_SET_ID'))
114: AND FFV.flex_value = p_value;
115: ELSE
116: /* Query to get the Descriptions of the Attribute values. */
117: SELECT FFV.description