DBA Data[Home] [Help]

APPS.IEU_SH_CON_PVT dependencies on FND_LOOKUP_VALUES

Line 611: FROM FND_LOOKUP_VALUES

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

Line 618: FROM FND_LOOKUP_VALUES

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

Line 625: FROM FND_LOOKUP_VALUES

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"');