DBA Data[Home] [Help]

APPS.ONT_OEXOEACK_XMLP_PKG dependencies on OE_LOOKUPS

Line 780: OE_LOOKUPS

776: SELECT
777: MEANING
778: INTO L_RETURN_VALUE
779: FROM
780: OE_LOOKUPS
781: WHERE LOOKUP_TYPE = 'OM_YES_NO'
782: AND LOOKUP_CODE = 'NO';
783: ELSE
784: SELECT

Line 788: OE_LOOKUPS

784: SELECT
785: MEANING
786: INTO L_RETURN_VALUE
787: FROM
788: OE_LOOKUPS
789: WHERE LOOKUP_TYPE = 'OM_YES_NO'
790: AND LOOKUP_CODE = 'YES';
791: END IF;
792: RETURN L_RETURN_VALUE;

Line 1263: FROM OE_LOOKUPS

1259: l_meaning VARCHAR2 (80);
1260: BEGIN
1261: SELECT MEANING
1262: INTO l_meaning
1263: FROM OE_LOOKUPS
1264: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
1265: AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
1266: ;
1267: