607: IF (p_appl_name = '1')
608: THEN
609: OPEN l_applCursor FOR
610: SELECT to_number(attribute2) APPL_ID
611: FROM FND_LOOKUP_VALUES
612: WHERE LOOKUP_TYPE = l_app_names and
613: LOOKUP_CODE = l_app_uwq;
614: ELSIF (p_appl_name = '2')
615: THEN
614: ELSIF (p_appl_name = '2')
615: THEN
616: OPEN l_applCursor FOR
617: SELECT to_number(attribute2) APPL_ID
618: FROM FND_LOOKUP_VALUES
619: WHERE LOOKUP_TYPE = l_app_names and
620: LOOKUP_CODE = l_app_emc;
621: ELSIF (p_appl_name = '3')
622: THEN
621: ELSIF (p_appl_name = '3')
622: THEN
623: OPEN l_applCursor FOR
624: SELECT to_number(attribute2) APPL_ID
625: FROM FND_LOOKUP_VALUES
626: WHERE LOOKUP_TYPE = l_app_names;
627: ELSE
628: RAISE_APPLICATION_ERROR (-20000,
629: 'Input must be "1" or "2" or "3"');