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.PER_RI_CONFIG_TECH_SUMMARY dependencies on HR_LOOKUPS

Line 241: select meaning into l_enabled from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';

237: BEGIN
238:
239: hr_utility.set_location('Entering ' || l_proc,10);
240:
241: select meaning into l_enabled from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';
242: l_org_class_clob := get_clob_locator('ORGANIZATIONS');
243: dbms_lob.createtemporary(l_org_class_clob,TRUE);
244:
245: hr_utility.set_location('Entering Enterprise Classification ',15);

Line 314: l_class_postjoin_sql := ' ), hr_lookups hrlkp '

310: end if;
311: hr_utility.set_location('Leaving LE Loop',60);
312: dbms_lob.trim(l_org_class_clob,length(l_org_class_clob)-5);
313:
314: l_class_postjoin_sql := ' ), hr_lookups hrlkp '
315: ||' where hrlkp.lookup_type= ''ORG_CLASS'''
316: ||' and hrlkp.lookup_code = org_classif_code ';
317:
318: dbms_lob.writeappend(l_org_class_clob,length(l_class_postjoin_sql),l_class_postjoin_sql);

Line 350: select meaning into l_enabled from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';

346:
347: BEGIN
348: hr_utility.set_location('Entering ' || l_proc,10);
349:
350: select meaning into l_enabled from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';
351: l_orderby := ' order by business_grp_name desc, name desc ';
352: l_org_class_clob_for_pv := get_clob_locator('ORGANIZATION_CLASSIF');
353: dbms_lob.createtemporary(l_org_class_clob_for_pv,TRUE);
354:

Line 377: select meaning into l_org_classif_val from hr_lookups where lookup_type= 'ORG_CLASS' and lookup_code = p_org_ent_class_tab(i).org_classif_code;

373:
374: l_org_classif_val := p_org_ent_class_tab(i).org_classif_code;
375: if p_org_ent_class_tab(i).org_classif_code is not null then
376: begin
377: select meaning into l_org_classif_val from hr_lookups where lookup_type= 'ORG_CLASS' and lookup_code = p_org_ent_class_tab(i).org_classif_code;
378: exception
379: when no_data_found then
380: null;
381: end;

Line 428: select meaning into l_org_classif_val from hr_lookups where lookup_type= 'ORG_CLASS' and lookup_code = p_org_oc_class_tab(i).org_classif_code;

424:
425: l_org_classif_val := p_org_oc_class_tab(i).org_classif_code;
426: if p_org_oc_class_tab(i).org_classif_code is not null then
427: begin
428: select meaning into l_org_classif_val from hr_lookups where lookup_type= 'ORG_CLASS' and lookup_code = p_org_oc_class_tab(i).org_classif_code;
429: exception
430: when no_data_found then
431: null;
432: end;

Line 483: select meaning into l_org_classif_val from hr_lookups where lookup_type= 'ORG_CLASS' and lookup_code = p_org_le_class_tab(i).org_classif_code;

479: l_org_classif_val := p_org_le_class_tab(i).org_classif_code;
480:
481: if p_org_le_class_tab(i).org_classif_code is not null then
482: begin
483: select meaning into l_org_classif_val from hr_lookups where lookup_type= 'ORG_CLASS' and lookup_code = p_org_le_class_tab(i).org_classif_code;
484: exception
485: when no_data_found then
486: null;
487: end;

Line 794: l_translated_prof_opt_value hr_lookups.meaning%type;

790: l_profile_clob clob;
791: queryCtx number(8) := 0;
792: l_prejoin_sql varchar2(2000);
793: l_postjoin_sql varchar2(2000);
794: l_translated_prof_opt_value hr_lookups.meaning%type;
795:
796: BEGIN
797: hr_utility.set_location('Entering ' || l_proc,10);
798: l_profile_clob := get_clob_locator('Profiles');

Line 821: select meaning into l_translated_prof_opt_value from hr_lookups where lookup_type = 'BUDGET_MEASUREMENT_TYPE' and lookup_code = 'HEAD';

817:
818: --Hardcoding for now
819: if p_profile_tab(i).profile_name = 'BIS_WORKFORCE_MEASUREMENT_TYPE'
820: and p_profile_tab(i).profile_option_value = 'HEAD' then
821: select meaning into l_translated_prof_opt_value from hr_lookups where lookup_type = 'BUDGET_MEASUREMENT_TYPE' and lookup_code = 'HEAD';
822: elsif p_profile_tab(i).profile_name = 'HR_GENERATE_GL_ORGS'
823: and p_profile_tab(i).profile_option_value = 'CCHR' then
824: select meaning into l_translated_prof_opt_value from hr_lookups where lookup_type like 'HR_GEN_GL_ORG' and lookup_code like 'CCHR';
825:

Line 824: select meaning into l_translated_prof_opt_value from hr_lookups where lookup_type like 'HR_GEN_GL_ORG' and lookup_code like 'CCHR';

820: and p_profile_tab(i).profile_option_value = 'HEAD' then
821: select meaning into l_translated_prof_opt_value from hr_lookups where lookup_type = 'BUDGET_MEASUREMENT_TYPE' and lookup_code = 'HEAD';
822: elsif p_profile_tab(i).profile_name = 'HR_GENERATE_GL_ORGS'
823: and p_profile_tab(i).profile_option_value = 'CCHR' then
824: select meaning into l_translated_prof_opt_value from hr_lookups where lookup_type like 'HR_GEN_GL_ORG' and lookup_code like 'CCHR';
825:
826: else
827: l_translated_prof_opt_value := p_profile_tab(i).profile_option_value;
828: end if;

Line 849: select meaning into l_translated_prof_opt_value from hr_lookups where lookup_type = 'BUDGET_MEASUREMENT_TYPE' and lookup_code = 'HEAD';

845:
846: --Hardcoding for now
847: if p_profile_tab(i).profile_name = 'BIS_WORKFORCE_MEASUREMENT_TYPE'
848: and p_profile_tab(i).profile_option_value = 'HEAD' then
849: select meaning into l_translated_prof_opt_value from hr_lookups where lookup_type = 'BUDGET_MEASUREMENT_TYPE' and lookup_code = 'HEAD';
850: else
851: l_translated_prof_opt_value := p_profile_tab(i).profile_option_value;
852: end if;
853:

Line 1040: select meaning into l_allow_dynamic from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';

1036:
1037: BEGIN
1038: hr_utility.set_location('Entering ' || l_proc,10);
1039:
1040: select meaning into l_allow_dynamic from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';
1041: l_enabled := l_allow_dynamic;
1042: l_freeze_flex_def := l_enabled;
1043:
1044: l_kf_str_clob := get_clob_locator('JobKeyFlexStruct');

Line 1449: select meaning into l_required from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';

1445:
1446: BEGIN
1447: hr_utility.set_location('Entering ' ||l_proc,20);
1448:
1449: select meaning into l_required from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';
1450: l_display := l_required;
1451: l_enabled := l_required;
1452: select meaning into l_vs_validation_type from fnd_lookups where lookup_type = 'SEG_VAL_TYPES' and lookup_code = 'I';
1453:

Line 1466: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_seg_tab(i).vs_security_available;

1462: if p_kf_job_seg_tab.count > 0 THEN
1463: for i in p_kf_job_seg_tab.first ..
1464: p_kf_job_seg_tab.last loop
1465: if p_kf_job_seg_tab(i).vs_security_available is not null then
1466: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_seg_tab(i).vs_security_available;
1467: end if;
1468: if p_kf_job_seg_tab(i).vs_enable_longlist is not null then
1469: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_seg_tab(i).vs_enable_longlist;
1470: end if;

Line 1514: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_rv_seg_tab(i).vs_security_available;

1510: for i in p_kf_job_rv_seg_tab.first ..
1511: p_kf_job_rv_seg_tab.last loop
1512:
1513: if p_kf_job_rv_seg_tab(i).vs_security_available is not null then
1514: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_rv_seg_tab(i).vs_security_available;
1515: end if;
1516: if p_kf_job_rv_seg_tab(i).vs_enable_longlist is not null then
1517: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_rv_seg_tab(i).vs_enable_longlist;
1518: end if;

Line 1561: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_security_available;

1557: for i in p_kf_job_no_rv_seg_tab.first ..
1558: p_kf_job_no_rv_seg_tab.last loop
1559:
1560: if p_kf_job_no_rv_seg_tab(i).vs_security_available is not null then
1561: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_security_available;
1562: end if;
1563: if p_kf_job_no_rv_seg_tab(i).vs_enable_longlist is not null then
1564: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_job_no_rv_seg_tab(i).vs_enable_longlist;
1565: end if;

Line 1625: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_seg_tab(i).vs_security_available;

1621: for i in p_kf_pos_seg_tab.first ..
1622: p_kf_pos_seg_tab.last loop
1623:
1624: if p_kf_pos_seg_tab(i).vs_security_available is not null then
1625: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_seg_tab(i).vs_security_available;
1626: end if;
1627: if p_kf_pos_seg_tab(i).vs_enable_longlist is not null then
1628: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_seg_tab(i).vs_enable_longlist;
1629: end if;

Line 1672: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_security_available;

1668: for i in p_kf_pos_rv_seg_tab.first ..
1669: p_kf_pos_rv_seg_tab.last loop
1670:
1671: if p_kf_pos_rv_seg_tab(i).vs_security_available is not null then
1672: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_security_available;
1673: end if;
1674: if p_kf_pos_rv_seg_tab(i).vs_enable_longlist is not null then
1675: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_rv_seg_tab(i).vs_enable_longlist;
1676: end if;

Line 1719: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_security_available;

1715: for i in p_kf_pos_no_rv_seg_tab.first ..
1716: p_kf_pos_no_rv_seg_tab.last loop
1717:
1718: if p_kf_pos_no_rv_seg_tab(i).vs_security_available is not null then
1719: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_security_available;
1720: end if;
1721: if p_kf_pos_no_rv_seg_tab(i).vs_enable_longlist is not null then
1722: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_pos_no_rv_seg_tab(i).vs_enable_longlist;
1723: end if;

Line 1784: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_seg_tab(i).vs_security_available;

1780: for i in p_kf_grd_seg_tab.first ..
1781: p_kf_grd_seg_tab.last loop
1782:
1783: if p_kf_grd_seg_tab(i).vs_security_available is not null then
1784: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_seg_tab(i).vs_security_available;
1785: end if;
1786: if p_kf_grd_seg_tab(i).vs_enable_longlist is not null then
1787: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_seg_tab(i).vs_enable_longlist;
1788: end if;

Line 1831: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_security_available;

1827: for i in p_kf_grd_rv_seg_tab.first ..
1828: p_kf_grd_rv_seg_tab.last loop
1829:
1830: if p_kf_grd_rv_seg_tab(i).vs_security_available is not null then
1831: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_security_available;
1832: end if;
1833: if p_kf_grd_rv_seg_tab(i).vs_enable_longlist is not null then
1834: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_rv_seg_tab(i).vs_enable_longlist;
1835: end if;

Line 1879: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_security_available;

1875: for i in p_kf_grd_no_rv_seg_tab.first ..
1876: p_kf_grd_no_rv_seg_tab.last loop
1877:
1878: if p_kf_grd_no_rv_seg_tab(i).vs_security_available is not null then
1879: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_security_available;
1880: end if;
1881: if p_kf_grd_no_rv_seg_tab(i).vs_enable_longlist is not null then
1882: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grd_no_rv_seg_tab(i).vs_enable_longlist;
1883: end if;

Line 1946: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grp_seg_tab(i).vs_security_available;

1942: for i in p_kf_grp_seg_tab.first ..
1943: p_kf_grp_seg_tab.last loop
1944:
1945: if p_kf_grp_seg_tab(i).vs_security_available is not null then
1946: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_grp_seg_tab(i).vs_security_available;
1947: end if;
1948: if p_kf_grp_seg_tab(i).vs_enable_longlist is not null then
1949: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_grp_seg_tab(i).vs_enable_longlist;
1950: end if;

Line 2011: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_cmp_seg_tab(i).vs_security_available;

2007: for i in p_kf_cmp_seg_tab.first ..
2008: p_kf_cmp_seg_tab.last loop
2009:
2010: if p_kf_cmp_seg_tab(i).vs_security_available is not null then
2011: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_cmp_seg_tab(i).vs_security_available;
2012: end if;
2013: if p_kf_cmp_seg_tab(i).vs_enable_longlist is not null then
2014: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_cmp_seg_tab(i).vs_enable_longlist;
2015: end if;

Line 2076: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_cost_seg_tab(i).vs_security_available;

2072: for i in p_kf_cost_seg_tab.first ..
2073: p_kf_cost_seg_tab.last loop
2074:
2075: if p_kf_cost_seg_tab(i).vs_security_available is not null then
2076: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_cost_seg_tab(i).vs_security_available;
2077: end if;
2078: if p_kf_cost_seg_tab(i).vs_enable_longlist is not null then
2079: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_cost_seg_tab(i).vs_enable_longlist;
2080: end if;

Line 2791: select meaning into l_allow_dynamic from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';

2787:
2788: BEGIN
2789: hr_utility.set_location('Entering ' ||l_proc,10);
2790:
2791: select meaning into l_allow_dynamic from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y';
2792: select meaning into l_vs_validation_type from fnd_lookups where lookup_type = 'SEG_VAL_TYPES' and lookup_code = 'I';
2793: l_enabled := l_allow_dynamic;
2794: l_required := l_allow_dynamic;
2795: l_display := l_allow_dynamic;

Line 2871: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_segment_tab(i).vs_security_available;

2867:
2868: -- When there is no data found error in the following places then do nothing
2869: begin
2870: if p_kf_segment_tab(i).vs_security_available is not null then
2871: select meaning into l_vs_security_available from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_kf_segment_tab(i).vs_security_available;
2872: end if;
2873: if p_kf_segment_tab(i).vs_enable_longlist is not null then
2874: select meaning into l_vs_enable_longlist from fnd_lookups where lookup_type = 'FLEX_VALUESET_LONGLIST_FLAG' and lookup_code = p_kf_segment_tab(i).vs_enable_longlist;
2875: end if;

Line 3079: l_postjoin_sql := ' )A , FND_TERRITORIES_VL terr ,fnd_currencies_vl curr,hr_lookups lookup '

3075: l_prejoin_sql := ' select terr.TERRITORY_SHORT_NAME Legislation , curr.name Currency, A.Tax_Start_Date, '
3076: ||' lookup.meaning Install_Tax_Unit_Val '
3077: ||' from ( ';
3078:
3079: l_postjoin_sql := ' )A , FND_TERRITORIES_VL terr ,fnd_currencies_vl curr,hr_lookups lookup '
3080: ||' where terr.TERRITORY_CODE = A.legislation_code '
3081: ||' and curr.currency_code = A.currency_code '
3082: ||' and lookup.lookup_code = A.install_tax_unit '
3083: ||' and lookup.lookup_type=''YES_NO'' and lookup.application_id=800 '