412: CURSOR GET_TEXT1 IS
413: SELECT
414: TEXT
415: FROM
416: QC_TEXT_TBL
417: WHERE TEXT_CODE = TEXTCODECF
418: AND LINE_NO <> - 1
419: AND LANG_CODE = 'US';
420: BEGIN
441: CURSOR GET_TEXT IS
442: SELECT
443: TEXT
444: FROM
445: QC_TEXT_TBL
446: WHERE TEXT_CODE = TEXTCODE1CF
447: AND LINE_NO <> - 1
448: AND LANG_CODE = 'US';
449: BEGIN
496: CURSOR GET_TEXT IS
497: SELECT
498: TEXT
499: FROM
500: QC_TEXT_TBL
501: WHERE TEXT_CODE = TEXT_CODE_1
502: AND LINE_NO <> - 1
503: AND LANG_CODE = 'US';
504: BEGIN
525: CURSOR GET_TEXT IS
526: SELECT
527: TEXT
528: FROM
529: QC_TEXT_TBL
530: WHERE TEXT_CODE = TEXT_CODE2
531: AND LINE_NO <> - 1
532: AND LANG_CODE = 'US';
533: BEGIN