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

Line 993: from per_addresses addr

989: upper(hr_general.decode_lookup('GB_COUNTY', substr(addr.region_1,1,35))) county,
990: addr.postal_code post_code,
991: upper(addr.town_or_city) town_or_city,
992: upper(addr.country) country
993: from per_addresses addr
994: where addr.person_id(+) = p_person_id
995: and ( addr.primary_flag = 'Y'
996: or addr.primary_flag is null)
997: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))

Line 1710: l_address_line1 per_addresses.address_line1%TYPE;

1706:
1707:
1708: l_national_insurance_number per_people_f.national_identifier%TYPE;
1709: l_assignment_number per_assignments_f.assignment_number%TYPE;
1710: l_address_line1 per_addresses.address_line1%TYPE;
1711: l_address_line2 per_addresses.address_line2%TYPE;
1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
1714: l_town_or_city per_addresses.town_or_city%TYPE;

Line 1711: l_address_line2 per_addresses.address_line2%TYPE;

1707:
1708: l_national_insurance_number per_people_f.national_identifier%TYPE;
1709: l_assignment_number per_assignments_f.assignment_number%TYPE;
1710: l_address_line1 per_addresses.address_line1%TYPE;
1711: l_address_line2 per_addresses.address_line2%TYPE;
1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
1714: l_town_or_city per_addresses.town_or_city%TYPE;
1715: l_county per_addresses.region_1%TYPE;

Line 1712: l_address_line3 per_addresses.address_line3%TYPE;

1708: l_national_insurance_number per_people_f.national_identifier%TYPE;
1709: l_assignment_number per_assignments_f.assignment_number%TYPE;
1710: l_address_line1 per_addresses.address_line1%TYPE;
1711: l_address_line2 per_addresses.address_line2%TYPE;
1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
1714: l_town_or_city per_addresses.town_or_city%TYPE;
1715: l_county per_addresses.region_1%TYPE;
1716: l_postal_code per_addresses.postal_code%TYPE;

Line 1713: l_address_line4 per_addresses.address_line3%TYPE;

1709: l_assignment_number per_assignments_f.assignment_number%TYPE;
1710: l_address_line1 per_addresses.address_line1%TYPE;
1711: l_address_line2 per_addresses.address_line2%TYPE;
1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
1714: l_town_or_city per_addresses.town_or_city%TYPE;
1715: l_county per_addresses.region_1%TYPE;
1716: l_postal_code per_addresses.postal_code%TYPE;
1717: l_last_name per_people_f.last_name%TYPE;

Line 1714: l_town_or_city per_addresses.town_or_city%TYPE;

1710: l_address_line1 per_addresses.address_line1%TYPE;
1711: l_address_line2 per_addresses.address_line2%TYPE;
1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
1714: l_town_or_city per_addresses.town_or_city%TYPE;
1715: l_county per_addresses.region_1%TYPE;
1716: l_postal_code per_addresses.postal_code%TYPE;
1717: l_last_name per_people_f.last_name%TYPE;
1718: l_first_name per_people_f.first_name%TYPE;

Line 1715: l_county per_addresses.region_1%TYPE;

1711: l_address_line2 per_addresses.address_line2%TYPE;
1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
1714: l_town_or_city per_addresses.town_or_city%TYPE;
1715: l_county per_addresses.region_1%TYPE;
1716: l_postal_code per_addresses.postal_code%TYPE;
1717: l_last_name per_people_f.last_name%TYPE;
1718: l_first_name per_people_f.first_name%TYPE;
1719: l_middle_name per_people_f.middle_names%TYPE;

Line 1716: l_postal_code per_addresses.postal_code%TYPE;

1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
1714: l_town_or_city per_addresses.town_or_city%TYPE;
1715: l_county per_addresses.region_1%TYPE;
1716: l_postal_code per_addresses.postal_code%TYPE;
1717: l_last_name per_people_f.last_name%TYPE;
1718: l_first_name per_people_f.first_name%TYPE;
1719: l_middle_name per_people_f.middle_names%TYPE;
1720: l_title per_people_f.title%TYPE;