APPS.OTA_CLASSIC_UPGRADE dependencies on HR_LOOKUPS

Line 92: From Hr_lookups lkp

88:
89: Begin
90:
91: Select lkp.Meaning into l_dm_name
92: From Hr_lookups lkp
93: Where lkp.lookup_type = 'ACTIVITY_CATEGORY'
94: And lkp.lookup_code = 'INCLASS' ;
95:
96: Open csr_check_dm(l_dm_name) ;

Line 367: from hr_lookups lkp

363: where ctu.type ='DM'
364: and nvl(ctu.online_flag,'N') = 'N'
365: and nvl(ctu.synchronous_flag,'Y')= 'Y'
366: and ctu.category in (select lkp.meaning
367: from hr_lookups lkp
368: where lkp.lookup_type = 'ACTIVITY_CATEGORY'
369: and lkp.lookup_code = 'INCLASS');
370:
371: cursor c_online_courses(p_dm_id number) is

Line 467: from hr_lookups lkp

463: where ctu.type = 'DM'
464: and nvl(ctu.online_flag,'N') = 'N'
465: and nvl(ctu.synchronous_flag,'Y')= 'Y'
466: and ctu.category not in (select lkp.meaning
467: from hr_lookups lkp
468: where lkp.lookup_type = 'ACTIVITY_CATEGORY'
469: and lkp.lookup_code = 'INCLASS');
470:
471: cursor c_online_courses(p_dm_id number) is

Line 768: FROM hr_lookups lkp

764: ota_mls_utility.set_session_language_code( l_userenv_language_code );
765:
766: update ota_category_usages ocu
767: set ocu.category = (SELECT lkp.meaning
768: FROM hr_lookups lkp
769: WHERE lkp.lookup_code = ocu.category
770: AND lkp.lookup_type = 'ACTIVITY_CATEGORY')
771: ,Synchronous_flag = Decode(Type,'C',NULL,'DM','Y')
772: ,Online_Flag = Decode(Type,'C',NULL,'DM','N')

Line 775: FROM hr_lookups lkp

771: ,Synchronous_flag = Decode(Type,'C',NULL,'DM','Y')
772: ,Online_Flag = Decode(Type,'C',NULL,'DM','N')
773: WHERE category_usage_id between p_start_pkid and p_end_pkid
774: AND exists (SELECT lkp.meaning
775: FROM hr_lookups lkp
776: WHERE lkp.lookup_code = ocu.category
777: AND lkp.lookup_type = 'ACTIVITY_CATEGORY') ;
778:
779:

Line 1266: --l_default_dm_name Hr_lookups.Meaning%Type ;

1262: l_min_course_start_date date;
1263: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
1264: hr_dflex_utility.l_ignore_dfcode_varray();
1265: --l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;
1266: --l_default_dm_name Hr_lookups.Meaning%Type ;
1267: --l_root_cat_usage_id ota_category_usages.category_usage_id%Type;
1268: --l_bg_name hr_organization_units.name%Type ;
1269: Begin
1270:

Line 1504: Ota_category_usages_vl ocu, hr_lookups lkp

1500: AND off.activity_version_id = p_act_ver_id;
1501:
1502: cursor c_def_dm_for_bg(l_bg_id number) is
1503: Select ocu.category_usage_id from
1504: Ota_category_usages_vl ocu, hr_lookups lkp
1505: Where Ocu.Category = Meaning
1506: and lkp.Lookup_type = 'ACTIVITY_CATEGORY'
1507: and lkp.lookup_code = 'INCLASS'
1508: and ocu.type = 'DM'