DBA Data[Home] [Help]

APPS.OTA_TEA_BUS dependencies on FND_PROFILE

Line 191: --l_cross_business_group varchar2(1):= fnd_profile.value('HR_CROSS_BUSINESS_GROUP') ;

187: ,p_position_id number
188: ) is
189: --
190: l_exists varchar2(1);
191: --l_cross_business_group varchar2(1):= fnd_profile.value('HR_CROSS_BUSINESS_GROUP') ;
192: l_business_group_id ota_events.business_group_id%type := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
193: --
194: cursor c_get_customer_association is
195: select 'X'

Line 192: l_business_group_id ota_events.business_group_id%type := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

188: ) is
189: --
190: l_exists varchar2(1);
191: --l_cross_business_group varchar2(1):= fnd_profile.value('HR_CROSS_BUSINESS_GROUP') ;
192: l_business_group_id ota_events.business_group_id%type := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
193: --
194: cursor c_get_customer_association is
195: select 'X'
196: from ota_event_associations