APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on HR_LOOKUPS

Line 1753: FROM per_addresses p_addr, hr_lookups hrl1

1749: RETURN NUMBER IS
1750: -- cursor to fetch country code stored in Address DDF for a person (Add_Attibute1)
1751: CURSOR csr_get_country_code(c_business_group_id NUMBER) IS
1752: SELECT hrl1.lookup_code
1753: FROM per_addresses p_addr, hr_lookups hrl1
1754: WHERE p_addr.person_id = g_person_id
1755: AND hrl1.lookup_type='PQP_NL_STUCON_CODE_MAPPING'
1756: AND hrl1.meaning = p_addr.country
1757: AND g_extract_params(c_business_group_id).extract_end_date >= p_addr.date_from;

Line 3062: FROM hr_lookups

3058:
3059:
3060: CURSOR c_city (p_lookup_code IN VARCHAR2) IS
3061: SELECT meaning
3062: FROM hr_lookups
3063: WHERE lookup_type = 'HR_NL_CITY'
3064: AND lookup_code = p_lookup_code;
3065:
3066:

Line 3068: l_city_name hr_lookups.meaning%TYPE;

3064: AND lookup_code = p_lookup_code;
3065:
3066:
3067: l_city per_addresses_v.town_or_city%TYPE;
3068: l_city_name hr_lookups.meaning%TYPE;
3069: l_country per_addresses_v.d_country%TYPE;
3070: l_code per_addresses_v.country%TYPE;
3071: l_proc_name Varchar2(150) := g_proc_name ||'Get_City';
3072: l_ret_val Number :=0;

Line 6937: hr_lookups hrl1

6933: ,c_effective_date IN DATE
6934: ) IS
6935: SELECT hrl1.lookup_code
6936: FROM ben_ext_chg_evt_log,
6937: hr_lookups hrl1
6938: WHERE person_id = g_person_id
6939: AND business_group_id = c_business_group_id
6940: AND chg_evt_cd = 'COCN'
6941: AND Substr(Nvl(old_val1,'-1'),0,7)=hrl1.meaning

Line 6961: hr_lookups hrl1

6957: --the ben_ext_chg_evt_log table in case a change has been made
6958: CURSOR c_get_old_cc( c_effective_date IN DATE) IS
6959: SELECT to_number(hrl1.lookup_code)
6960: FROM ben_ext_chg_evt_log,
6961: hr_lookups hrl1
6962: WHERE chg_evt_cd = 'COCN'
6963: AND ( chg_eff_dt between g_extract_params(p_business_group_id).extract_start_date
6964: and g_extract_params(p_business_group_id).extract_end_date )
6965: AND Substr(Nvl(old_val1,'-1'),0,7)=hrl1.meaning

Line 6975: hr_lookups hrl1

6971: --the ben_ext_chg_evt_log table in case a change has been made
6972: CURSOR c_get_new_cc(c_effective_date IN DATE) IS
6973: SELECT to_number(hrl1.lookup_code)
6974: FROM ben_ext_chg_evt_log,
6975: hr_lookups hrl1
6976: WHERE chg_evt_cd = 'COCN'
6977: AND ( chg_eff_dt between g_extract_params(p_business_group_id).extract_start_date
6978: and g_extract_params(p_business_group_id).extract_end_date )
6979: AND Substr(Nvl(new_val1,'-1'),0,7)=hrl1.meaning