APPS.AS_OPPORTUNITY_VUHK dependencies on OE_LOOKUPS

Line 132: from oe_lookups a, pv_channel_types b

128: cursor lc_chk_channel_code (pc_code varchar2) is
129: select
130: a.meaning,
131: nvl(b.indirect_channel_flag, 'N')
132: from oe_lookups a, pv_channel_types b
133: where a.lookup_type = 'SALES_CHANNEL'
134: and a.lookup_code = pc_code
135: and a.lookup_type = b.channel_lookup_type (+)
136: and a.lookup_code = b.channel_lookup_code (+);