DBA Data[Home] [Help]

APPS.BIS_RSG_PMV_REPORT_PKG dependencies on FND_LOOKUPS

Line 119: SELECT MEANING INTO l_meaning FROM FND_LOOKUPS

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

Line 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: