APPS.OTA_OCL_BUS dependencies on OTA_COMPETENCE_LANGUAGES

Line 39: , ota_competence_languages ocl

35: --
36: cursor csr_sec_grp is
37: select pbg.security_group_id
38: from per_business_groups pbg
39: , ota_competence_languages ocl
40: where ocl.competence_language_id = p_competence_language_id
41: and pbg.business_group_id = ocl.business_group_id;
42: --
43: -- Declare local variables

Line 99: , ota_competence_languages ocl

95: --
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , ota_competence_languages ocl
100: where ocl.competence_language_id = p_competence_language_id
101: and pbg.business_group_id = ocl.business_group_id;
102: --
103: -- Declare local variables

Line 247: ,p_descflex_name => 'OTA_COMPETENCE_LANGUAGES'

243: -- b) During insert.
244: --
245: hr_dflex_utility.ins_or_upd_descflex_attribs
246: (p_appl_short_name => 'OTA'
247: ,p_descflex_name => 'OTA_COMPETENCE_LANGUAGES'
248: -- ,p_attribute20_name => 'OCL_INFORMATION20'
249: -- ,p_attribute20_value => p_rec.ocl_information20
250: ,p_attribute_category => p_rec.OCL_INFORMATION_CATEGORY
251: ,p_attribute1_name => 'OCL_INFORMATION1'