APPS.AS_OPPORTUNITY_VUHK dependencies on AS_LEADS_ALL

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: