47: --
48: --Cursor to fetch Review Length for the Corps from Extra Info
49: CURSOR csr_review_length IS
50: SELECT TO_NUMBER(pgi_information3)
51: FROM ben_pgm_extra_info
52: WHERE information_type = 'PQH_FR_CORP_INFO'
53: AND pgm_id = p_ben_pgm_id;
54: --
55: --Variable Declarations.
110: --
111: --Cursor to fetch Appraisal Type for the Corps
112: CURSOR csr_appraisal_type IS
113: SELECT pgi_information2
114: FROM ben_pgm_extra_info
115: WHERE information_type = 'PQH_FR_CORP_INFO'
116: AND pgm_id = p_ben_pgm_id;
117: --
118: --Cursor to fetch Appraisal Date