115: BEGIN
116: -- if status code is normal('C') then we have to display Completed, else take the value for
117: -- that status code
118: IF (p_status_code = 'C') THEN
119: SELECT MEANING INTO l_meaning FROM FND_LOOKUPS
120: WHERE LOOKUP_TYPE = 'CP_PHASE_CODE' AND
121: LOOKUP_CODE = p_phase_code;
122: ELSE
123: SELECT MEANING INTO l_meaning FROM FND_LOOKUPS
119: SELECT MEANING INTO l_meaning FROM FND_LOOKUPS
120: WHERE LOOKUP_TYPE = 'CP_PHASE_CODE' AND
121: LOOKUP_CODE = p_phase_code;
122: ELSE
123: SELECT MEANING INTO l_meaning FROM FND_LOOKUPS
124: WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND
125: LOOKUP_CODE = p_status_code;
126: END IF;
127: