APPS.OTA_TDB_BUS2 dependencies on FND_PROFILE

Line 352: FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

348: p_date_booking_placed in date) is
349: l_proc varchar2(72) := g_package||'check_org_business_group';
350: l_dummy varchar2(30);
351: l_global_bg ota_delegate_bookings.business_group_id%type :=
352: FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
353: --
354: --
355: cursor c_person (l_person_id number) is
356: select 1

Line 516: AND DECODE(fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'),

512: where PARTY_SITE.location_id = LOC.location_id
513: and ACCT_SITE.party_site_id = PARTY_SITE.party_site_id
514: and ACCT_SITE.CUST_ACCOUNT_ID = p_customer_id
515: and ACCT_SITE.CUST_ACCT_SITE_ID = p_contact_address_id
516: AND DECODE(fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'),
517: null, (NVL(ORG_ID , NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO'),1,1),' ',
518: NULL, SUBSTRB( USERENV('CLIENT_INFO'),1,10))),
519: -99))), 1 ) =
520: DECODE(fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'),

Line 520: DECODE(fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'),

516: AND DECODE(fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'),
517: null, (NVL(ORG_ID , NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO'),1,1),' ',
518: NULL, SUBSTRB( USERENV('CLIENT_INFO'),1,10))),
519: -99))), 1 ) =
520: DECODE(fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'),
521: null, (NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO'),1,1),' ',
522: NULL,SUBSTRB(USERENV( 'CLIENT_INFO'),1,10))),
523: -99)),1 );
524: