DBA Data[Home] [Help]

APPS.ONT_OEXOEACK_XMLP_PKG dependencies on OE_LOOKUPS

Line 779: OE_LOOKUPS

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

Line 787: OE_LOOKUPS

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

Line 1262: FROM OE_LOOKUPS

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