APPS.OTA_NHS_BUS dependencies on OTA_NOTRNG_HISTORIES

Line 24: , ota_notrng_histories nth

20: --
21: cursor csr_sec_grp is
22: select pbg.security_group_id
23: from per_business_groups pbg
24: , ota_notrng_histories nth
25: where nth.nota_history_id = p_nota_history_id
26: and pbg.business_group_id = nth.business_group_id;
27: --
28: -- Declare local variables

Line 85: , ota_notrng_histories nth

81: --
82: cursor csr_leg_code is
83: select pbg.legislation_code
84: from per_business_groups pbg
85: , ota_notrng_histories nth
86: where nth.nota_history_id = p_nota_history_id
87: and pbg.business_group_id = nth.business_group_id;
88: --
89: -- Declare local variables

Line 235: ,p_descflex_name => 'OTA_NOTRNG_HISTORIES'

231: -- b) During insert.
232: --
233: hr_dflex_utility.ins_or_upd_descflex_attribs
234: (p_appl_short_name => 'OTA'
235: ,p_descflex_name => 'OTA_NOTRNG_HISTORIES'
236: ,p_attribute_category => p_rec.NTH_INFORMATION_CATEGORY
237: ,p_attribute1_name => 'NTH_INFORMATION1'
238: ,p_attribute1_value => p_rec.nth_information1
239: ,p_attribute2_name => 'NTH_INFORMATION2'

Line 379: l_single_business_group_id ota_notrng_histories.business_group_id%type;

375: ,p_effective_date in date) is
376:
377: --
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: