APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 345: FROM per_addresses addr

341: ,addr.address_line3 address_line3
342: ,addr.town_or_city town_or_city
343: ,hr_general.decode_lookup('ES_PROVINCE_CODES',addr.region_2) prov
344: ,addr.postal_code postal_code
345: FROM per_addresses addr
346: WHERE addr.person_id = p_person_id
347: AND addr.primary_flag = 'Y'
348: AND p_termination_date between addr.date_from and
349: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'));

Line 353: l_province per_addresses.region_2%type ;

349: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'));
350: --
351: l_addr csr_person_addr%rowtype;
352: l_found boolean;
353: l_province per_addresses.region_2%type ;
354: l_action_info_id NUMBER;
355: l_ovn NUMBER;
356: --
357: BEGIN

Line 407: l_province per_addresses.region_2%type ;

403: AND hou.location_id = addr.location_id;
404: --
405: l_found BOOLEAN;
406: l_employer_addr csr_employer_addr%rowtype;
407: l_province per_addresses.region_2%type ;
408: l_action_info_id NUMBER;
409: l_ovn number;
410: --
411: BEGIN