APPS.AS_OPPORTUNITY_VUHK dependencies on FND_PROFILE

Line 118: select fnd_profile.value('PV_USER_TYPE'),

114: l_api_name CONSTANT VARCHAR2(30) := 'update_opp_header_pre';
115: l_api_version_number CONSTANT NUMBER := 2.0;
116:
117: cursor lc_get_channel_type (pc_lead_id number) is
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