188: CURSOR SORT_BY_HEADER_CUR IS
189: SELECT
190: MEANING || ':'
191: FROM
192: PSP_LOOKUPS PL
193: WHERE PL.LOOKUP_TYPE = 'PSP_ENC_EXC_REP_SORT_OPTIONS'
194: AND PL.LOOKUP_CODE = P_SORT_BY;
195: CURSOR SORT_BY_DETAIL_CUR IS
196: SELECT
195: CURSOR SORT_BY_DETAIL_CUR IS
196: SELECT
197: MEANING
198: FROM
199: PSP_LOOKUPS PL
200: WHERE PL.LOOKUP_TYPE = 'PSP_ENC_EXC_REP_SORT_OPTIONS'
201: AND PL.LOOKUP_CODE <> P_SORT_BY;
202: L_SORT_BY_HEADER PSP_LOOKUPS.MEANING%TYPE;
203: BEGIN
198: FROM
199: PSP_LOOKUPS PL
200: WHERE PL.LOOKUP_TYPE = 'PSP_ENC_EXC_REP_SORT_OPTIONS'
201: AND PL.LOOKUP_CODE <> P_SORT_BY;
202: L_SORT_BY_HEADER PSP_LOOKUPS.MEANING%TYPE;
203: BEGIN
204: OPEN SORT_BY_DETAIL_CUR;
205: FETCH SORT_BY_DETAIL_CUR
206: INTO CP_SORT_BY_DETAIL;