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.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_ADDRESSES

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 2831: FROM per_addresses_v

2827:
2828:
2829: CURSOR cur_get_street(c_person_id IN Number) IS
2830: SELECT region_1
2831: FROM per_addresses_v
2832: WHERE person_id = c_person_id
2833: AND p_effective_date BETWEEN date_from
2834: AND Nvl(date_to,Hr_Api.g_eot)
2835: AND primary_flag = 'Y'

Line 2839: FROM per_addresses_v

2835: AND primary_flag = 'Y'
2836: AND style = 'NL'
2837: UNION
2838: SELECT address_line1
2839: FROM per_addresses_v
2840: WHERE person_id = c_person_id
2841: AND p_effective_date BETWEEN date_from
2842: AND Nvl(date_to,Hr_Api.g_eot)
2843: AND primary_flag = 'Y'

Line 2846: l_street per_addresses_v.region_1%TYPE;

2842: AND Nvl(date_to,Hr_Api.g_eot)
2843: AND primary_flag = 'Y'
2844: AND style = 'NL_GLB';
2845:
2846: l_street per_addresses_v.region_1%TYPE;
2847: l_proc_name Varchar2(150) := g_proc_name ||'Get_Street';
2848:
2849: BEGIN
2850: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 2881: FROM per_addresses_v

2877: ) RETURN Number IS
2878:
2879: CURSOR cur_get_house_num(c_person_id IN Number) IS
2880: SELECT add_information13
2881: FROM per_addresses_v
2882: WHERE person_id = c_person_id
2883: AND p_effective_date BETWEEN date_from
2884: AND Nvl(date_to,Hr_Api.g_eot)
2885: AND style = 'NL'

Line 2889: FROM per_addresses_v

2885: AND style = 'NL'
2886: AND primary_flag = 'Y'
2887: UNION
2888: SELECT address_line2
2889: FROM per_addresses_v
2890: WHERE person_id = c_person_id
2891: AND p_effective_date BETWEEN date_from
2892: AND Nvl(date_to,Hr_Api.g_eot)
2893: AND style = 'NL_GLB'

Line 2897: l_house_num per_addresses_v.address_line1%TYPE;

2893: AND style = 'NL_GLB'
2894: AND primary_flag = 'Y';
2895:
2896:
2897: l_house_num per_addresses_v.address_line1%TYPE;
2898: l_proc_name Varchar2(150) := g_proc_name ||'Get_House_Num';
2899: l_ret_val Number := 0;
2900:
2901: BEGIN

Line 2932: FROM per_addresses_v

2928:
2929:
2930: CURSOR cur_get_addl_house_num(c_person_id IN Number) IS
2931: SELECT add_information14
2932: FROM per_addresses_v
2933: WHERE person_id = c_person_id
2934: AND p_effective_date BETWEEN date_from
2935: AND Nvl(date_to,Hr_Api.g_eot)
2936: AND primary_flag = 'Y'

Line 2940: FROM per_addresses_v

2936: AND primary_flag = 'Y'
2937: AND style = 'NL'
2938: UNION
2939: SELECT address_line3
2940: FROM per_addresses_v
2941: WHERE person_id = c_person_id
2942: AND p_effective_date BETWEEN date_from
2943: AND Nvl(date_to,Hr_Api.g_eot)
2944: AND primary_flag = 'Y'

Line 2947: l_addl_house_num per_addresses_v.address_line1%TYPE;

2943: AND Nvl(date_to,Hr_Api.g_eot)
2944: AND primary_flag = 'Y'
2945: AND style = 'NL_GLB';
2946:
2947: l_addl_house_num per_addresses_v.address_line1%TYPE;
2948: l_proc_name Varchar2(150) := g_proc_name ||'Get_Addnl_House_Num';
2949: l_ret_val Number := 0;
2950:
2951: BEGIN

Line 2985: FROM per_addresses_v

2981:
2982:
2983: CURSOR cur_get_postal_code(c_person_id IN Number) IS
2984: SELECT postal_code
2985: FROM per_addresses_v
2986: WHERE person_id = c_person_id
2987: AND p_effective_date BETWEEN date_from
2988: AND Nvl(date_to,Hr_Api.g_eot)
2989: AND style IN ('NL','NL_GLB')

Line 2992: l_postal_code per_addresses_v.postal_code%TYPE;

2988: AND Nvl(date_to,Hr_Api.g_eot)
2989: AND style IN ('NL','NL_GLB')
2990: AND primary_flag = 'Y';
2991:
2992: l_postal_code per_addresses_v.postal_code%TYPE;
2993: l_postal_code1 per_addresses_v.postal_code%TYPE;
2994: temp_str varchar2(1);
2995: i Number := 0;
2996: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';

Line 2993: l_postal_code1 per_addresses_v.postal_code%TYPE;

2989: AND style IN ('NL','NL_GLB')
2990: AND primary_flag = 'Y';
2991:
2992: l_postal_code per_addresses_v.postal_code%TYPE;
2993: l_postal_code1 per_addresses_v.postal_code%TYPE;
2994: temp_str varchar2(1);
2995: i Number := 0;
2996: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';
2997: l_ret_val Number :=0;

Line 3042: FROM per_addresses_v

3038:
3039:
3040: CURSOR cur_get_city(c_person_id IN Number) IS
3041: SELECT town_or_city
3042: FROM per_addresses_v
3043: WHERE person_id = c_person_id
3044: AND p_effective_date BETWEEN date_from
3045: AND Nvl(date_to,Hr_Api.g_eot)
3046: AND style IN ('NL','NL_GLB')

Line 3052: FROM per_addresses_v

3048:
3049: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
3050: SELECT Decode(country,'NL','N',country) code
3051: ,d_country
3052: FROM per_addresses_v
3053: WHERE person_id = c_person_id
3054: AND p_effective_date BETWEEN date_from
3055: AND Nvl(date_to,Hr_Api.g_eot)
3056: AND style IN ('NL','NL_GLB')

Line 3067: l_city per_addresses_v.town_or_city%TYPE;

3063: WHERE lookup_type = 'HR_NL_CITY'
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';

Line 3069: l_country per_addresses_v.d_country%TYPE;

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;
3073:

Line 3070: l_code per_addresses_v.country%TYPE;

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;
3073:
3074: BEGIN