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

7200:
7201:
7202: CURSOR cur_get_street(c_person_id IN Number) IS
7203: SELECT region_1
7204: FROM per_addresses_v
7205: WHERE person_id = c_person_id
7206: AND p_effective_date BETWEEN date_from
7207: AND Nvl(date_to,Hr_Api.g_eot)
7208: AND primary_flag = 'Y'

Line 7212: FROM per_addresses_v

7208: AND primary_flag = 'Y'
7209: AND style = 'NL'
7210: UNION
7211: SELECT address_line1
7212: FROM per_addresses_v
7213: WHERE person_id = c_person_id
7214: AND p_effective_date BETWEEN date_from
7215: AND Nvl(date_to,Hr_Api.g_eot)
7216: AND primary_flag = 'Y'

Line 7219: l_street per_addresses_v.region_1%TYPE;

7215: AND Nvl(date_to,Hr_Api.g_eot)
7216: AND primary_flag = 'Y'
7217: AND style = 'NL_GLB';
7218:
7219: l_street per_addresses_v.region_1%TYPE;
7220: l_proc_name Varchar2(150) := g_proc_name ||'Get_Street';
7221:
7222: BEGIN
7223: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 7254: FROM per_addresses_v

7250: ) RETURN Number IS
7251:
7252: CURSOR cur_get_house_num(c_person_id IN Number) IS
7253: SELECT add_information13
7254: FROM per_addresses_v
7255: WHERE person_id = c_person_id
7256: AND p_effective_date BETWEEN date_from
7257: AND Nvl(date_to,Hr_Api.g_eot)
7258: AND style = 'NL'

Line 7262: FROM per_addresses_v

7258: AND style = 'NL'
7259: AND primary_flag = 'Y'
7260: UNION
7261: SELECT address_line2
7262: FROM per_addresses_v
7263: WHERE person_id = c_person_id
7264: AND p_effective_date BETWEEN date_from
7265: AND Nvl(date_to,Hr_Api.g_eot)
7266: AND style = 'NL_GLB'

Line 7269: l_house_num per_addresses_v.address_line1%TYPE;

7265: AND Nvl(date_to,Hr_Api.g_eot)
7266: AND style = 'NL_GLB'
7267: AND primary_flag = 'Y';
7268:
7269: l_house_num per_addresses_v.address_line1%TYPE;
7270: l_proc_name Varchar2(150) := g_proc_name ||'Get_House_Num';
7271: l_ret_val Number := -1;
7272:
7273: BEGIN

Line 7309: FROM per_addresses_v

7305:
7306:
7307: CURSOR cur_get_addl_house_num(c_person_id IN Number) IS
7308: SELECT add_information14
7309: FROM per_addresses_v
7310: WHERE person_id = c_person_id
7311: AND p_effective_date BETWEEN date_from
7312: AND Nvl(date_to,Hr_Api.g_eot)
7313: AND primary_flag = 'Y'

Line 7317: FROM per_addresses_v

7313: AND primary_flag = 'Y'
7314: AND style = 'NL'
7315: UNION
7316: SELECT address_line3
7317: FROM per_addresses_v
7318: WHERE person_id = c_person_id
7319: AND p_effective_date BETWEEN date_from
7320: AND Nvl(date_to,Hr_Api.g_eot)
7321: AND primary_flag = 'Y'

Line 7324: l_addl_house_num per_addresses_v.address_line1%TYPE;

7320: AND Nvl(date_to,Hr_Api.g_eot)
7321: AND primary_flag = 'Y'
7322: AND style = 'NL_GLB';
7323:
7324: l_addl_house_num per_addresses_v.address_line1%TYPE;
7325: l_proc_name Varchar2(150) := g_proc_name ||'Get_Addnl_House_Num';
7326: l_ret_val Number := -1;
7327:
7328: BEGIN

Line 7364: FROM per_addresses_v

7360:
7361:
7362: CURSOR cur_get_postal_code(c_person_id IN Number) IS
7363: SELECT postal_code
7364: FROM per_addresses_v
7365: WHERE person_id = c_person_id
7366: AND p_effective_date BETWEEN date_from
7367: AND Nvl(date_to,Hr_Api.g_eot)
7368: AND style IN ('NL','NL_GLB')

Line 7371: l_postal_code per_addresses_v.postal_code%TYPE;

7367: AND Nvl(date_to,Hr_Api.g_eot)
7368: AND style IN ('NL','NL_GLB')
7369: AND primary_flag = 'Y';
7370:
7371: l_postal_code per_addresses_v.postal_code%TYPE;
7372: l_postal_code1 per_addresses_v.postal_code%TYPE;
7373: temp_str varchar2(1);
7374: i Number := 0;
7375: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';

Line 7372: l_postal_code1 per_addresses_v.postal_code%TYPE;

7368: AND style IN ('NL','NL_GLB')
7369: AND primary_flag = 'Y';
7370:
7371: l_postal_code per_addresses_v.postal_code%TYPE;
7372: l_postal_code1 per_addresses_v.postal_code%TYPE;
7373: temp_str varchar2(1);
7374: i Number := 0;
7375: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';
7376: l_ret_val Number := -1;

Line 7424: FROM per_addresses_v

7420:
7421:
7422: CURSOR cur_get_city(c_person_id IN Number) IS
7423: SELECT town_or_city
7424: FROM per_addresses_v
7425: WHERE person_id = c_person_id
7426: AND p_effective_date BETWEEN date_from
7427: AND Nvl(date_to,Hr_Api.g_eot)
7428: AND style IN ('NL','NL_GLB')

Line 7434: FROM per_addresses_v

7430:
7431: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
7432: SELECT Decode(country,'NL','N',country) code
7433: ,d_country
7434: FROM per_addresses_v
7435: WHERE person_id = c_person_id
7436: AND p_effective_date BETWEEN date_from
7437: AND Nvl(date_to,Hr_Api.g_eot)
7438: AND style IN ('NL','NL_GLB')

Line 7449: l_city per_addresses_v.town_or_city%TYPE;

7445: WHERE lookup_type = 'HR_NL_CITY'
7446: AND lookup_code = p_lookup_code;
7447:
7448:
7449: l_city per_addresses_v.town_or_city%TYPE;
7450: l_city_name hr_lookups.meaning%TYPE;
7451: l_country per_addresses_v.d_country%TYPE;
7452: l_code per_addresses_v.country%TYPE;
7453: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';

Line 7451: l_country per_addresses_v.d_country%TYPE;

7447:
7448:
7449: l_city per_addresses_v.town_or_city%TYPE;
7450: l_city_name hr_lookups.meaning%TYPE;
7451: l_country per_addresses_v.d_country%TYPE;
7452: l_code per_addresses_v.country%TYPE;
7453: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';
7454: l_ret_val Number := -1;
7455:

Line 7452: l_code per_addresses_v.country%TYPE;

7448:
7449: l_city per_addresses_v.town_or_city%TYPE;
7450: l_city_name hr_lookups.meaning%TYPE;
7451: l_country per_addresses_v.d_country%TYPE;
7452: l_code per_addresses_v.country%TYPE;
7453: l_proc_name Varchar2(150) := g_proc_name ||'Get_Postal_Code';
7454: l_ret_val Number := -1;
7455:
7456: BEGIN

Line 7507: FROM per_addresses_v

7503: ) RETURN Number IS
7504:
7505: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
7506: SELECT Decode(country,'NL',' ','J')
7507: FROM per_addresses_v
7508: WHERE person_id = c_person_id
7509: AND p_effective_date BETWEEN date_from
7510: AND Nvl(date_to,Hr_Api.g_eot)
7511: AND style IN ('NL','NL_GLB')

Line 7514: l_country per_addresses_v.d_country%TYPE;

7510: AND Nvl(date_to,Hr_Api.g_eot)
7511: AND style IN ('NL','NL_GLB')
7512: AND primary_flag = 'Y';
7513:
7514: l_country per_addresses_v.d_country%TYPE;
7515: l_proc_name Varchar2(150) := g_proc_name ||'Get_Foreign_Country';
7516: l_ret_val Number := 0;
7517:
7518: BEGIN

Line 7567: FROM per_addresses_v

7563: AND effective_end_date;
7564:
7565: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
7566: SELECT DECODE(country,'NL','N','J')
7567: FROM per_addresses_v
7568: WHERE person_id = c_person_id
7569: AND p_effective_date BETWEEN date_from
7570: AND NVL(date_to,hr_api.g_eot)
7571: AND style IN('NL','NL_GLB')

Line 8476: FROM per_addresses_v

8472: -- Cursor to check if the country of residence is a foreign ( non NL ) country
8473: --
8474: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS
8475: SELECT DECODE(country,'NL','N','J')
8476: FROM per_addresses_v
8477: WHERE person_id = c_person_id
8478: AND p_effective_date BETWEEN date_from
8479: AND NVL(date_to,hr_api.g_eot)
8480: AND style IN('NL','NL_GLB')

Line 8519: FROM per_addresses_v padr

8515: ,c_business_group_id IN NUMBER
8516: ,c_ext_start_date IN DATE
8517: ,c_ext_end_date IN DATE ) IS
8518: SELECT 1
8519: FROM per_addresses_v padr
8520: WHERE person_id = c_person_id
8521: -- if the current primary address is not in NL
8522: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8523: AND primary_flag = 'Y'

Line 8544: FROM per_addresses_v padr

8540: ,c_business_group_id IN NUMBER
8541: ,c_ext_start_date IN DATE
8542: ,c_ext_end_date IN DATE ) IS
8543: SELECT 1
8544: FROM per_addresses_v padr
8545: WHERE person_id = c_person_id
8546: -- if the current primary address is in NL
8547: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8548: AND primary_flag = 'Y'

Line 8562: FROM per_addresses_v adr

8558: AND log.prmtr_02 IS NOT NULL
8559: AND fnd_date.canonical_to_date(prmtr_09)
8560: BETWEEN c_ext_start_date AND c_ext_end_date
8561: AND EXISTS (SELECT 1
8562: FROM per_addresses_v adr
8563: WHERE adr.person_id = log.person_id
8564: AND adr.address_id = to_number(log.prmtr_02)
8565: -- old address was not in NL
8566: AND country <> 'NL'));

Line 8590: FROM per_addresses_v padr

8586: --
8587: CURSOR c_get_cc (c_code IN VARCHAR2
8588: ,c_addr_id IN NUMBER) IS
8589: SELECT 1
8590: FROM per_addresses_v padr
8591: WHERE person_id = g_person_id
8592: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8593: AND address_id = c_addr_id
8594: AND primary_flag = 'Y'