APPS.PER_RI_CONFIG_TECH_SUMMARY dependencies on FND_LOOKUP_VALUES

Line 103: l_bg_postjoin_sql := ' ) X ,FND_TERRITORIES_VL terr ,fnd_lookup_values lookup1, '

99: end if;
100: hr_utility.set_location('Leaving BG Loop',20);
101: dbms_lob.trim(l_bg_clob,length(l_bg_clob)-5);
102:
103: l_bg_postjoin_sql := ' ) X ,FND_TERRITORIES_VL terr ,fnd_lookup_values lookup1, '
104: ||' fnd_lookup_values lookup2,fnd_lookup_values lookup3 , '
105: ||' fnd_currencies_vl curr '
106: ||' where terr.TERRITORY_CODE = X.Legislation_code '
107: ||' and lookup1.lookup_code= app_gen_method '

Line 104: ||' fnd_lookup_values lookup2,fnd_lookup_values lookup3 , '

100: hr_utility.set_location('Leaving BG Loop',20);
101: dbms_lob.trim(l_bg_clob,length(l_bg_clob)-5);
102:
103: l_bg_postjoin_sql := ' ) X ,FND_TERRITORIES_VL terr ,fnd_lookup_values lookup1, '
104: ||' fnd_lookup_values lookup2,fnd_lookup_values lookup3 , '
105: ||' fnd_currencies_vl curr '
106: ||' where terr.TERRITORY_CODE = X.Legislation_code '
107: ||' and lookup1.lookup_code= app_gen_method '
108: ||' and lookup2.lookup_code = emp_gen_method '

Line 947: l_prof_opt_value fnd_lookup_values.meaning%type;

943: l_profile_resp_clob clob;
944: queryCtx number(8) := 0;
945: l_prejoin_sql varchar2(2000);
946: l_postjoin_sql varchar2(2000);
947: l_prof_opt_value fnd_lookup_values.meaning%type;
948:
949: BEGIN
950: hr_utility.set_location('Entering ' || l_proc,10);
951: l_profile_resp_clob := get_clob_locator('profile_resp');

Line 970: select meaning into l_prof_opt_value from fnd_lookup_values where lookup_type = 'HR_USER_TYPE' and language = userenv('LANG') and lookup_code like p_profile_resp_tab(i).profile_option_value;

966: for i in p_profile_resp_tab.first ..
967: p_profile_resp_tab.last loop
968:
969: if p_profile_resp_tab(i).profile_name = 'HR_USER_TYPE' then
970: select meaning into l_prof_opt_value from fnd_lookup_values where lookup_type = 'HR_USER_TYPE' and language = userenv('LANG') and lookup_code like p_profile_resp_tab(i).profile_option_value;
971: else
972: l_prof_opt_value := p_profile_resp_tab(i).profile_option_value;
973: end if;
974: