DBA Data[Home] [Help]

APPS.OTA_NHS_BUS dependencies on OTA_EVENTS

Line 382: l_business_group_id ota_events.business_group_id%type ;

378: l_proc varchar2(72) := g_package||'chk_organization_id';
379: l_single_business_group_id ota_notrng_histories.business_group_id%type;
380: l_exists varchar2(1);
381: l_cross_business_group varchar2(1);
382: l_business_group_id ota_events.business_group_id%type ;
383:
384: --
385: -- cursor to check if oganization id is valid.
386: --

Line 502: l_business_group_id ota_events.business_group_id%type ;

498: --
499: l_proc varchar2(72) := g_package||'chk_person_id';
500: l_exists varchar2(1);
501: l_cross_business_group varchar2(1) ;
502: l_business_group_id ota_events.business_group_id%type ;
503:
504: --
505: -- cursor to check is person id is belong to customer.
506: --