11: CURSOR CUR_GET_DESCRIPTION IS
12: SELECT
13: DESCRIPTION
14: FROM
15: IGI_LOOKUPS
16: WHERE UPPER(LOOKUP_CODE) = 'SIA'
17: AND LOOKUP_TYPE = 'GCC_DESCRIPTION';
18: L_DESCRIPTION IGI_LOOKUPS.DESCRIPTION%TYPE;
19: BEGIN
14: FROM
15: IGI_LOOKUPS
16: WHERE UPPER(LOOKUP_CODE) = 'SIA'
17: AND LOOKUP_TYPE = 'GCC_DESCRIPTION';
18: L_DESCRIPTION IGI_LOOKUPS.DESCRIPTION%TYPE;
19: BEGIN
20: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
21: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
22: OPEN CUR_GET_DESCRIPTION;
49: SELECT
50: LOOKUP_CODE
51: INTO P_RELEASE_LOOKUP_CODE_1
52: FROM
53: IGI_LOOKUPS
54: WHERE LOOKUP_TYPE = 'REPORTS'
55: AND MEANING = P_RELEASE_LOOKUP_CODE;
56: END IF;
57: RETURN (TRUE);