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.

[Home] [Help]

APPS.OTA_UTILITY dependencies on HR_LOOKUPS

Line 822: from hr_lookups

818: p_application_id number) return varchar2 is
819: --
820: cursor csr_lookup is
821: select meaning
822: from hr_lookups
823: where lookup_type = p_lookup_type
824: and lookup_code = p_lookup_code
825: and enabled_flag = 'Y';
826: --

Line 1276: hr_lookups lookup

1272: SELECT lookup.meaning Dm_Name,
1273: catusg.category Dm_Code
1274: FROM ota_act_cat_inclusions actcat,
1275: ota_category_usages catusg,
1276: hr_lookups lookup
1277: WHERE actcat.category_usage_id= catusg.category_usage_id
1278: AND actcat.primary_flag='Y'
1279: AND catusg.category = lookup.lookup_code
1280: AND lookup.lookup_type ='ACTIVITY_CATEGORY'

Line 1289: hr_lookups lookup

1285: SELECT lookup.meaning dm_name,
1286: catusg.category dm_code
1287: FROM ota_act_cat_inclusions actcat,
1288: ota_category_usages catusg,
1289: hr_lookups lookup
1290: WHERE actcat.category_usage_id= catusg.category_usage_id
1291: AND catusg.category = lookup.lookup_code
1292: AND lookup.lookup_type ='ACTIVITY_CATEGORY'
1293: AND catusg.type='DM'

Line 1300: FROM hr_lookups

1296: -- Added for Bug No.2941052
1297: -- Get Delivery Method name corresponding to code 'INCLASS'
1298: CURSOR get_dm_name IS
1299: SELECT meaning
1300: FROM hr_lookups
1301: WHERE lookup_type ='ACTIVITY_CATEGORY'
1302: AND lookup_code = 'INCLASS';
1303:
1304: l_proc VARCHAR2(72) := g_package||'Get_Delivery_Method';

Line 1306: l_pr_dm_cat hr_lookups.lookup_code%TYPE;

1302: AND lookup_code = 'INCLASS';
1303:
1304: l_proc VARCHAR2(72) := g_package||'Get_Delivery_Method';
1305:
1306: l_pr_dm_cat hr_lookups.lookup_code%TYPE;
1307: l_pr_dm_name hr_lookups.meaning%TYPE;
1308:
1309:
1310: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';

Line 1307: l_pr_dm_name hr_lookups.meaning%TYPE;

1303:
1304: l_proc VARCHAR2(72) := g_package||'Get_Delivery_Method';
1305:
1306: l_pr_dm_cat hr_lookups.lookup_code%TYPE;
1307: l_pr_dm_name hr_lookups.meaning%TYPE;
1308:
1309:
1310: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';
1311: l_return_dm_name hr_lookups.meaning%TYPE;

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

1306: l_pr_dm_cat hr_lookups.lookup_code%TYPE;
1307: l_pr_dm_name hr_lookups.meaning%TYPE;
1308:
1309:
1310: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';
1311: l_return_dm_name hr_lookups.meaning%TYPE;
1312: l_return VARCHAR2(100);
1313: l_counter NUMBER := 0;
1314:

Line 1311: l_return_dm_name hr_lookups.meaning%TYPE;

1307: l_pr_dm_name hr_lookups.meaning%TYPE;
1308:
1309:
1310: l_return_dm_cat hr_lookups.lookup_code%TYPE := 'INCLASS';
1311: l_return_dm_name hr_lookups.meaning%TYPE;
1312: l_return VARCHAR2(100);
1313: l_counter NUMBER := 0;
1314:
1315: BEGIN

Line 1875: hr_lookups lookup

1871: SELECT lookup.meaning Dm_Name,
1872: catusg.category Dm_Code
1873: FROM ota_act_cat_inclusions actcat,
1874: ota_category_usages catusg,
1875: hr_lookups lookup
1876: WHERE actcat.category_usage_id= catusg.category_usage_id
1877: AND actcat.primary_flag='Y'
1878: AND catusg.category = lookup.lookup_code
1879: AND lookup.lookup_type ='ACTIVITY_CATEGORY'

Line 1888: hr_lookups lookup

1884: SELECT lookup.meaning dm_name,
1885: catusg.category dm_code
1886: FROM ota_act_cat_inclusions actcat,
1887: ota_category_usages catusg,
1888: hr_lookups lookup
1889: WHERE actcat.category_usage_id= catusg.category_usage_id
1890: AND catusg.category = lookup.lookup_code
1891: AND lookup.lookup_type ='ACTIVITY_CATEGORY'
1892: AND catusg.type='C'

Line 1897: l_pr_dm_name hr_lookups.meaning%TYPE;

1893: AND actcat.activity_version_id = p_activity_version_id;
1894:
1895: l_proc VARCHAR2(72) := g_package||'Get_category_name';
1896:
1897: l_pr_dm_name hr_lookups.meaning%TYPE;
1898:
1899: l_return_dm_name hr_lookups.meaning%TYPE := 'Classroom (physical)';
1900: l_return VARCHAR2(100);
1901: l_counter NUMBER := 0;

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

1895: l_proc VARCHAR2(72) := g_package||'Get_category_name';
1896:
1897: l_pr_dm_name hr_lookups.meaning%TYPE;
1898:
1899: l_return_dm_name hr_lookups.meaning%TYPE := 'Classroom (physical)';
1900: l_return VARCHAR2(100);
1901: l_counter NUMBER := 0;
1902:
1903: BEGIN

Line 3313: FROM hr_lookups

3309: WHERE booking_id = p_booking_id);
3310:
3311: CURSOR crs_enr_change_reason_lang(p_lookup_code in varchar2) IS
3312: SELECT meaning
3313: FROM hr_lookups
3314: WHERE lookup_type = 'ENROLMENT_STATUS_REASON'
3315: AND enabled_flag = 'Y'
3316: AND lookup_code = p_lookup_code;
3317: