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_PENSION_EXTRACTS dependencies on PER_ADDRESSES_V

Line 6865: FROM per_addresses_v

6861:
6862:
6863: CURSOR cur_get_street(c_person_id IN Number) IS
6864: SELECT region_1
6865: FROM per_addresses_v
6866: WHERE person_id = c_person_id
6867: AND p_effective_date BETWEEN date_from
6868: AND Nvl(date_to,Hr_Api.g_eot)
6869: AND primary_flag = 'Y'

Line 6873: FROM per_addresses_v

6869: AND primary_flag = 'Y'
6870: AND style = 'NL'
6871: UNION
6872: SELECT address_line1
6873: FROM per_addresses_v
6874: WHERE person_id = c_person_id
6875: AND p_effective_date BETWEEN date_from
6876: AND Nvl(date_to,Hr_Api.g_eot)
6877: AND primary_flag = 'Y'

Line 6880: l_street per_addresses_v.region_1%TYPE;

6876: AND Nvl(date_to,Hr_Api.g_eot)
6877: AND primary_flag = 'Y'
6878: AND style = 'NL_GLB';
6879:
6880: l_street per_addresses_v.region_1%TYPE;
6881: l_proc_name Varchar2(150) := g_proc_name ||'Get_Street';
6882:
6883: BEGIN
6884: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 6915: FROM per_addresses_v

6911: ) RETURN Number IS
6912:
6913: CURSOR cur_get_house_num(c_person_id IN Number) IS
6914: SELECT add_information13
6915: FROM per_addresses_v
6916: WHERE person_id = c_person_id
6917: AND p_effective_date BETWEEN date_from
6918: AND Nvl(date_to,Hr_Api.g_eot)
6919: AND style = 'NL'

Line 6923: FROM per_addresses_v

6919: AND style = 'NL'
6920: AND primary_flag = 'Y'
6921: UNION
6922: SELECT address_line2
6923: FROM per_addresses_v
6924: WHERE person_id = c_person_id
6925: AND p_effective_date BETWEEN date_from
6926: AND Nvl(date_to,Hr_Api.g_eot)
6927: AND style = 'NL_GLB'

Line 6930: l_house_num per_addresses_v.address_line1%TYPE;

6926: AND Nvl(date_to,Hr_Api.g_eot)
6927: AND style = 'NL_GLB'
6928: AND primary_flag = 'Y';
6929:
6930: l_house_num per_addresses_v.address_line1%TYPE;
6931: l_proc_name Varchar2(150) := g_proc_name ||'Get_House_Num';
6932: l_ret_val Number := -1;
6933:
6934: BEGIN

Line 6970: FROM per_addresses_v

6966:
6967:
6968: CURSOR cur_get_addl_house_num(c_person_id IN Number) IS
6969: SELECT add_information14
6970: FROM per_addresses_v
6971: WHERE person_id = c_person_id
6972: AND p_effective_date BETWEEN date_from
6973: AND Nvl(date_to,Hr_Api.g_eot)
6974: AND primary_flag = 'Y'

Line 6978: FROM per_addresses_v

6974: AND primary_flag = 'Y'
6975: AND style = 'NL'
6976: UNION
6977: SELECT address_line3
6978: FROM per_addresses_v
6979: WHERE person_id = c_person_id
6980: AND p_effective_date BETWEEN date_from
6981: AND Nvl(date_to,Hr_Api.g_eot)
6982: AND primary_flag = 'Y'

Line 6985: l_addl_house_num per_addresses_v.address_line1%TYPE;

6981: AND Nvl(date_to,Hr_Api.g_eot)
6982: AND primary_flag = 'Y'
6983: AND style = 'NL_GLB';
6984:
6985: l_addl_house_num per_addresses_v.address_line1%TYPE;
6986: l_proc_name Varchar2(150) := g_proc_name ||'Get_Addnl_House_Num';
6987: l_ret_val Number := -1;
6988:
6989: BEGIN

Line 7025: FROM per_addresses_v

7021:
7022:
7023: CURSOR cur_get_postal_code(c_person_id IN Number) IS
7024: SELECT postal_code
7025: FROM per_addresses_v
7026: WHERE person_id = c_person_id
7027: AND p_effective_date BETWEEN date_from
7028: AND Nvl(date_to,Hr_Api.g_eot)
7029: AND style IN ('NL','NL_GLB')

Line 7032: l_postal_code per_addresses_v.postal_code%TYPE;

7028: AND Nvl(date_to,Hr_Api.g_eot)
7029: AND style IN ('NL','NL_GLB')
7030: AND primary_flag = 'Y';
7031:
7032: l_postal_code per_addresses_v.postal_code%TYPE;
7033: l_postal_code1 per_addresses_v.postal_code%TYPE;
7034: temp_str varchar2(1);
7035: i Number := 0;
7036: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';

Line 7033: l_postal_code1 per_addresses_v.postal_code%TYPE;

7029: AND style IN ('NL','NL_GLB')
7030: AND primary_flag = 'Y';
7031:
7032: l_postal_code per_addresses_v.postal_code%TYPE;
7033: l_postal_code1 per_addresses_v.postal_code%TYPE;
7034: temp_str varchar2(1);
7035: i Number := 0;
7036: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';
7037: l_ret_val Number := -1;

Line 7085: FROM per_addresses_v

7081:
7082:
7083: CURSOR cur_get_city(c_person_id IN Number) IS
7084: SELECT town_or_city
7085: FROM per_addresses_v
7086: WHERE person_id = c_person_id
7087: AND p_effective_date BETWEEN date_from
7088: AND Nvl(date_to,Hr_Api.g_eot)
7089: AND style IN ('NL','NL_GLB')

Line 7095: FROM per_addresses_v

7091:
7092: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
7093: SELECT Decode(country,'NL','N',country) code
7094: ,d_country
7095: FROM per_addresses_v
7096: WHERE person_id = c_person_id
7097: AND p_effective_date BETWEEN date_from
7098: AND Nvl(date_to,Hr_Api.g_eot)
7099: AND style IN ('NL','NL_GLB')

Line 7110: l_city per_addresses_v.town_or_city%TYPE;

7106: WHERE lookup_type = 'HR_NL_CITY'
7107: AND lookup_code = p_lookup_code;
7108:
7109:
7110: l_city per_addresses_v.town_or_city%TYPE;
7111: l_city_name hr_lookups.meaning%TYPE;
7112: l_country per_addresses_v.d_country%TYPE;
7113: l_code per_addresses_v.country%TYPE;
7114: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';

Line 7112: l_country per_addresses_v.d_country%TYPE;

7108:
7109:
7110: l_city per_addresses_v.town_or_city%TYPE;
7111: l_city_name hr_lookups.meaning%TYPE;
7112: l_country per_addresses_v.d_country%TYPE;
7113: l_code per_addresses_v.country%TYPE;
7114: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';
7115: l_ret_val Number := -1;
7116:

Line 7113: l_code per_addresses_v.country%TYPE;

7109:
7110: l_city per_addresses_v.town_or_city%TYPE;
7111: l_city_name hr_lookups.meaning%TYPE;
7112: l_country per_addresses_v.d_country%TYPE;
7113: l_code per_addresses_v.country%TYPE;
7114: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';
7115: l_ret_val Number := -1;
7116:
7117: BEGIN

Line 7168: FROM per_addresses_v

7164: ) RETURN Number IS
7165:
7166: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
7167: SELECT Decode(country,'NL',' ','J')
7168: FROM per_addresses_v
7169: WHERE person_id = c_person_id
7170: AND p_effective_date BETWEEN date_from
7171: AND Nvl(date_to,Hr_Api.g_eot)
7172: AND style IN ('NL','NL_GLB')

Line 7175: l_country per_addresses_v.d_country%TYPE;

7171: AND Nvl(date_to,Hr_Api.g_eot)
7172: AND style IN ('NL','NL_GLB')
7173: AND primary_flag = 'Y';
7174:
7175: l_country per_addresses_v.d_country%TYPE;
7176: l_proc_name Varchar2(150) := g_proc_name ||'Get_Foreign_Country';
7177: l_ret_val Number := 0;
7178:
7179: BEGIN

Line 7228: FROM per_addresses_v

7224: AND effective_end_date;
7225:
7226: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
7227: SELECT DECODE(country,'NL','N','J')
7228: FROM per_addresses_v
7229: WHERE person_id = c_person_id
7230: AND p_effective_date BETWEEN date_from
7231: AND NVL(date_to,hr_api.g_eot)
7232: AND style IN('NL','NL_GLB')

Line 8137: FROM per_addresses_v

8133: -- Cursor to check if the country of residence is a foreign ( non NL ) country
8134: --
8135: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
8136: SELECT DECODE(country,'NL','N','J')
8137: FROM per_addresses_v
8138: WHERE person_id = c_person_id
8139: AND p_effective_date BETWEEN date_from
8140: AND NVL(date_to,hr_api.g_eot)
8141: AND style IN('NL','NL_GLB')

Line 8180: FROM per_addresses_v padr

8176: ,c_business_group_id IN NUMBER
8177: ,c_ext_start_date IN DATE
8178: ,c_ext_end_date IN DATE ) IS
8179: SELECT 1
8180: FROM per_addresses_v padr
8181: WHERE person_id = c_person_id
8182: -- if the current primary address is not in NL
8183: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8184: AND primary_flag = 'Y'

Line 8205: FROM per_addresses_v padr

8201: ,c_business_group_id IN NUMBER
8202: ,c_ext_start_date IN DATE
8203: ,c_ext_end_date IN DATE ) IS
8204: SELECT 1
8205: FROM per_addresses_v padr
8206: WHERE person_id = c_person_id
8207: -- if the current primary address is in NL
8208: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8209: AND primary_flag = 'Y'

Line 8223: FROM per_addresses_v adr

8219: AND log.prmtr_02 IS NOT NULL
8220: AND fnd_date.canonical_to_date(prmtr_09)
8221: BETWEEN c_ext_start_date AND c_ext_end_date
8222: AND EXISTS (SELECT 1
8223: FROM per_addresses_v adr
8224: WHERE adr.person_id = log.person_id
8225: AND adr.address_id = to_number(log.prmtr_02)
8226: -- old address was not in NL
8227: AND country <> 'NL'));

Line 8251: FROM per_addresses_v padr

8247: --
8248: CURSOR c_get_cc (c_code IN VARCHAR2
8249: ,c_addr_id IN NUMBER) IS
8250: SELECT 1
8251: FROM per_addresses_v padr
8252: WHERE person_id = g_person_id
8253: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8254: AND address_id = c_addr_id
8255: AND primary_flag = 'Y'