APPS.PV_OPPORTUNITY_VHUK dependencies on OE_LOOKUPS

Line 2319: from oe_lookups a, pv_channel_types b

2315: -- Find out the channel type of the opportunity: DIRECT or INDIRECT.
2316: -- -----------------------------------------------------------------
2317: FOR x IN (
2318: select nvl(b.indirect_channel_flag, 'N') indirect_channel_flag
2319: from oe_lookups a, pv_channel_types b
2320: where a.lookup_type = 'SALES_CHANNEL'
2321: and a.lookup_code = l_channel_code
2322: and a.lookup_type = b.channel_lookup_type (+)
2323: and a.lookup_code = b.channel_lookup_code (+))

Line 2557: from oe_lookups a, pv_channel_types b

2553:
2554: cursor lc_chk_channel_code (pc_code varchar2) is
2555: --select a.meaning, nvl(b.indirect_channel_flag, 'N')
2556: select nvl(b.indirect_channel_flag, 'N')
2557: from oe_lookups a, pv_channel_types b
2558: where a.lookup_type = 'SALES_CHANNEL'
2559: and a.lookup_code = pc_code
2560: and a.lookup_type = b.channel_lookup_type (+)
2561: and a.lookup_code = b.channel_lookup_code (+);