eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_UTILITY dependencies on HR_LOOKUPS

Line 886: from hr_lookups

882: p_application_id number) return varchar2 is
883: --
884: cursor csr_lookup is
885: select meaning
886: from hr_lookups
887: where lookup_type = p_lookup_type
888: and lookup_code = p_lookup_code
889: and enabled_flag = 'Y';
890: --

Line 1340: hr_lookups lookup

1336: SELECT lookup.meaning Dm_Name,
1337: catusg.category Dm_Code
1338: FROM ota_act_cat_inclusions actcat,
1339: ota_category_usages catusg,
1340: hr_lookups lookup
1341: WHERE actcat.category_usage_id= catusg.category_usage_id
1342: AND actcat.primary_flag='Y'
1343: AND catusg.category = lookup.lookup_code
1344: AND lookup.lookup_type ='ACTIVITY_CATEGORY'

Line 1353: hr_lookups lookup

1349: SELECT lookup.meaning dm_name,
1350: catusg.category dm_code
1351: FROM ota_act_cat_inclusions actcat,
1352: ota_category_usages catusg,
1353: hr_lookups lookup
1354: WHERE actcat.category_usage_id= catusg.category_usage_id
1355: AND catusg.category = lookup.lookup_code
1356: AND lookup.lookup_type ='ACTIVITY_CATEGORY'
1357: AND catusg.type='DM'

Line 1364: FROM hr_lookups

1360: -- Added for Bug No.2941052
1361: -- Get Delivery Method name corresponding to code 'INCLASS'
1362: CURSOR get_dm_name IS
1363: SELECT meaning
1364: FROM hr_lookups
1365: WHERE lookup_type ='ACTIVITY_CATEGORY'
1366: AND lookup_code = 'INCLASS';
1367:
1368: l_proc VARCHAR2(72) := g_package||'Get_Delivery_Method';

Line 1370: l_pr_dm_cat hr_lookups.lookup_code%TYPE;

1366: AND lookup_code = 'INCLASS';
1367:
1368: l_proc VARCHAR2(72) := g_package||'Get_Delivery_Method';
1369:
1370: l_pr_dm_cat hr_lookups.lookup_code%TYPE;
1371: l_pr_dm_name hr_lookups.meaning%TYPE;
1372:
1373:
1374: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';

Line 1371: l_pr_dm_name hr_lookups.meaning%TYPE;

1367:
1368: l_proc VARCHAR2(72) := g_package||'Get_Delivery_Method';
1369:
1370: l_pr_dm_cat hr_lookups.lookup_code%TYPE;
1371: l_pr_dm_name hr_lookups.meaning%TYPE;
1372:
1373:
1374: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';
1375: l_return_dm_name hr_lookups.meaning%TYPE;

Line 1374: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';

1370: l_pr_dm_cat hr_lookups.lookup_code%TYPE;
1371: l_pr_dm_name hr_lookups.meaning%TYPE;
1372:
1373:
1374: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';
1375: l_return_dm_name hr_lookups.meaning%TYPE;
1376: l_return VARCHAR2(100);
1377: l_counter NUMBER := 0;
1378:

Line 1375: l_return_dm_name hr_lookups.meaning%TYPE;

1371: l_pr_dm_name hr_lookups.meaning%TYPE;
1372:
1373:
1374: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';
1375: l_return_dm_name hr_lookups.meaning%TYPE;
1376: l_return VARCHAR2(100);
1377: l_counter NUMBER := 0;
1378:
1379: BEGIN

Line 1939: hr_lookups lookup

1935: SELECT lookup.meaning Dm_Name,
1936: catusg.category Dm_Code
1937: FROM ota_act_cat_inclusions actcat,
1938: ota_category_usages catusg,
1939: hr_lookups lookup
1940: WHERE actcat.category_usage_id= catusg.category_usage_id
1941: AND actcat.primary_flag='Y'
1942: AND catusg.category = lookup.lookup_code
1943: AND lookup.lookup_type ='ACTIVITY_CATEGORY'

Line 1952: hr_lookups lookup

1948: SELECT lookup.meaning dm_name,
1949: catusg.category dm_code
1950: FROM ota_act_cat_inclusions actcat,
1951: ota_category_usages catusg,
1952: hr_lookups lookup
1953: WHERE actcat.category_usage_id= catusg.category_usage_id
1954: AND catusg.category = lookup.lookup_code
1955: AND lookup.lookup_type ='ACTIVITY_CATEGORY'
1956: AND catusg.type='C'

Line 1961: l_pr_dm_name hr_lookups.meaning%TYPE;

1957: AND actcat.activity_version_id = p_activity_version_id;
1958:
1959: l_proc VARCHAR2(72) := g_package||'Get_category_name';
1960:
1961: l_pr_dm_name hr_lookups.meaning%TYPE;
1962:
1963: l_return_dm_name hr_lookups.meaning%TYPE := 'Classroom (physical)';
1964: l_return VARCHAR2(100);
1965: l_counter NUMBER := 0;

Line 1963: l_return_dm_name hr_lookups.meaning%TYPE := 'Classroom (physical)';

1959: l_proc VARCHAR2(72) := g_package||'Get_category_name';
1960:
1961: l_pr_dm_name hr_lookups.meaning%TYPE;
1962:
1963: l_return_dm_name hr_lookups.meaning%TYPE := 'Classroom (physical)';
1964: l_return VARCHAR2(100);
1965: l_counter NUMBER := 0;
1966:
1967: BEGIN

Line 3396: FROM hr_lookups

3392: WHERE booking_id = p_booking_id);
3393:
3394: CURSOR crs_enr_change_reason_lang(p_lookup_code in varchar2) IS
3395: SELECT meaning
3396: FROM hr_lookups
3397: WHERE lookup_type = 'ENROLMENT_STATUS_REASON'
3398: AND enabled_flag = 'Y'
3399: AND lookup_code = p_lookup_code;
3400: