APPS.AS_OPPORTUNITY_VUHK dependencies on PV_CHANNEL_TYPES

Line 122: from as_leads_all a, pv_channel_types c

118: select fnd_profile.value('PV_USER_TYPE'),
119: a.channel_code,
120: decode(nvl(c.channel_lookup_code,'0'), '0', 'N', c.indirect_channel_flag ),
121: a.prm_assignment_type
122: from as_leads_all a, pv_channel_types c
123: where a.lead_id = pc_lead_id
124: and a.channel_code = c.channel_lookup_code(+)
125: and c.channel_lookup_type (+) = 'SALES_CHANNEL';
126:

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 (+);