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_RTI_EAS dependencies on PER_ADDRESSES

Line 153: l_address_line1 per_addresses.address_line1%TYPE;

149:
150: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_address_rec';
151: l_arch boolean;
152: --Address Details
153: l_address_line1 per_addresses.address_line1%TYPE;
154: l_address_line2 per_addresses.address_line2%TYPE;
155: l_address_line3 per_addresses.address_line3%TYPE;
156: l_address_line4 per_addresses.address_line3%TYPE;
157:

Line 154: l_address_line2 per_addresses.address_line2%TYPE;

150: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_address_rec';
151: l_arch boolean;
152: --Address Details
153: l_address_line1 per_addresses.address_line1%TYPE;
154: l_address_line2 per_addresses.address_line2%TYPE;
155: l_address_line3 per_addresses.address_line3%TYPE;
156: l_address_line4 per_addresses.address_line3%TYPE;
157:
158: cursor csr_address is

Line 155: l_address_line3 per_addresses.address_line3%TYPE;

151: l_arch boolean;
152: --Address Details
153: l_address_line1 per_addresses.address_line1%TYPE;
154: l_address_line2 per_addresses.address_line2%TYPE;
155: l_address_line3 per_addresses.address_line3%TYPE;
156: l_address_line4 per_addresses.address_line3%TYPE;
157:
158: cursor csr_address is
159: select upper(substr(trim(addr.address_line1),1,35)) addr1,

Line 156: l_address_line4 per_addresses.address_line3%TYPE;

152: --Address Details
153: l_address_line1 per_addresses.address_line1%TYPE;
154: l_address_line2 per_addresses.address_line2%TYPE;
155: l_address_line3 per_addresses.address_line3%TYPE;
156: l_address_line4 per_addresses.address_line3%TYPE;
157:
158: cursor csr_address is
159: select upper(substr(trim(addr.address_line1),1,35)) addr1,
160: upper(substr(trim(addr.address_line2),1,35)) addr2,

Line 165: from per_addresses addr

161: upper(substr(trim(addr.address_line3),1,35)) addr3,
162: substr(addr.postal_code,1,10) post_code,
163: upper(substr(trim(addr.town_or_city),1,35)) addr4,
164: upper(substr(trim(addr.country),1,35)) country
165: from per_addresses addr
166: where addr.person_id = p_person_id
167: and ( addr.primary_flag = 'Y'
168: or addr.primary_flag is null)
169: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))

Line 1310: l_address_line1 per_addresses.address_line1%TYPE;

1306:
1307: l_assignment_number per_assignments_f.assignment_number%TYPE;
1308:
1309: --address details
1310: l_address_line1 per_addresses.address_line1%TYPE;
1311: l_address_line2 per_addresses.address_line2%TYPE;
1312: l_address_line3 per_addresses.address_line3%TYPE;
1313: l_address_line4 per_addresses.address_line3%TYPE;
1314: l_town_or_city per_addresses.town_or_city%TYPE;

Line 1311: l_address_line2 per_addresses.address_line2%TYPE;

1307: l_assignment_number per_assignments_f.assignment_number%TYPE;
1308:
1309: --address details
1310: l_address_line1 per_addresses.address_line1%TYPE;
1311: l_address_line2 per_addresses.address_line2%TYPE;
1312: l_address_line3 per_addresses.address_line3%TYPE;
1313: l_address_line4 per_addresses.address_line3%TYPE;
1314: l_town_or_city per_addresses.town_or_city%TYPE;
1315: l_postal_code per_addresses.postal_code%TYPE;

Line 1312: l_address_line3 per_addresses.address_line3%TYPE;

1308:
1309: --address details
1310: l_address_line1 per_addresses.address_line1%TYPE;
1311: l_address_line2 per_addresses.address_line2%TYPE;
1312: l_address_line3 per_addresses.address_line3%TYPE;
1313: l_address_line4 per_addresses.address_line3%TYPE;
1314: l_town_or_city per_addresses.town_or_city%TYPE;
1315: l_postal_code per_addresses.postal_code%TYPE;
1316: l_country per_addresses.country%TYPE; --R

Line 1313: l_address_line4 per_addresses.address_line3%TYPE;

1309: --address details
1310: l_address_line1 per_addresses.address_line1%TYPE;
1311: l_address_line2 per_addresses.address_line2%TYPE;
1312: l_address_line3 per_addresses.address_line3%TYPE;
1313: l_address_line4 per_addresses.address_line3%TYPE;
1314: l_town_or_city per_addresses.town_or_city%TYPE;
1315: l_postal_code per_addresses.postal_code%TYPE;
1316: l_country per_addresses.country%TYPE; --R
1317:

Line 1314: l_town_or_city per_addresses.town_or_city%TYPE;

1310: l_address_line1 per_addresses.address_line1%TYPE;
1311: l_address_line2 per_addresses.address_line2%TYPE;
1312: l_address_line3 per_addresses.address_line3%TYPE;
1313: l_address_line4 per_addresses.address_line3%TYPE;
1314: l_town_or_city per_addresses.town_or_city%TYPE;
1315: l_postal_code per_addresses.postal_code%TYPE;
1316: l_country per_addresses.country%TYPE; --R
1317:
1318:

Line 1315: l_postal_code per_addresses.postal_code%TYPE;

1311: l_address_line2 per_addresses.address_line2%TYPE;
1312: l_address_line3 per_addresses.address_line3%TYPE;
1313: l_address_line4 per_addresses.address_line3%TYPE;
1314: l_town_or_city per_addresses.town_or_city%TYPE;
1315: l_postal_code per_addresses.postal_code%TYPE;
1316: l_country per_addresses.country%TYPE; --R
1317:
1318:
1319: --person details

Line 1316: l_country per_addresses.country%TYPE; --R

1312: l_address_line3 per_addresses.address_line3%TYPE;
1313: l_address_line4 per_addresses.address_line3%TYPE;
1314: l_town_or_city per_addresses.town_or_city%TYPE;
1315: l_postal_code per_addresses.postal_code%TYPE;
1316: l_country per_addresses.country%TYPE; --R
1317:
1318:
1319: --person details
1320: l_last_name per_people_f.last_name%TYPE;

Line 1548: l_address_line1 per_addresses.address_line1%TYPE;

1544:
1545: l_assignment_number per_assignments_f.assignment_number%TYPE;
1546:
1547: --address details
1548: l_address_line1 per_addresses.address_line1%TYPE;
1549: l_address_line2 per_addresses.address_line2%TYPE;
1550: l_address_line3 per_addresses.address_line3%TYPE;
1551: l_address_line4 per_addresses.address_line3%TYPE;
1552: l_town_or_city per_addresses.town_or_city%TYPE;

Line 1549: l_address_line2 per_addresses.address_line2%TYPE;

1545: l_assignment_number per_assignments_f.assignment_number%TYPE;
1546:
1547: --address details
1548: l_address_line1 per_addresses.address_line1%TYPE;
1549: l_address_line2 per_addresses.address_line2%TYPE;
1550: l_address_line3 per_addresses.address_line3%TYPE;
1551: l_address_line4 per_addresses.address_line3%TYPE;
1552: l_town_or_city per_addresses.town_or_city%TYPE;
1553: l_postal_code per_addresses.postal_code%TYPE;

Line 1550: l_address_line3 per_addresses.address_line3%TYPE;

1546:
1547: --address details
1548: l_address_line1 per_addresses.address_line1%TYPE;
1549: l_address_line2 per_addresses.address_line2%TYPE;
1550: l_address_line3 per_addresses.address_line3%TYPE;
1551: l_address_line4 per_addresses.address_line3%TYPE;
1552: l_town_or_city per_addresses.town_or_city%TYPE;
1553: l_postal_code per_addresses.postal_code%TYPE;
1554: l_country per_addresses.country%TYPE; --R

Line 1551: l_address_line4 per_addresses.address_line3%TYPE;

1547: --address details
1548: l_address_line1 per_addresses.address_line1%TYPE;
1549: l_address_line2 per_addresses.address_line2%TYPE;
1550: l_address_line3 per_addresses.address_line3%TYPE;
1551: l_address_line4 per_addresses.address_line3%TYPE;
1552: l_town_or_city per_addresses.town_or_city%TYPE;
1553: l_postal_code per_addresses.postal_code%TYPE;
1554: l_country per_addresses.country%TYPE; --R
1555:

Line 1552: l_town_or_city per_addresses.town_or_city%TYPE;

1548: l_address_line1 per_addresses.address_line1%TYPE;
1549: l_address_line2 per_addresses.address_line2%TYPE;
1550: l_address_line3 per_addresses.address_line3%TYPE;
1551: l_address_line4 per_addresses.address_line3%TYPE;
1552: l_town_or_city per_addresses.town_or_city%TYPE;
1553: l_postal_code per_addresses.postal_code%TYPE;
1554: l_country per_addresses.country%TYPE; --R
1555:
1556:

Line 1553: l_postal_code per_addresses.postal_code%TYPE;

1549: l_address_line2 per_addresses.address_line2%TYPE;
1550: l_address_line3 per_addresses.address_line3%TYPE;
1551: l_address_line4 per_addresses.address_line3%TYPE;
1552: l_town_or_city per_addresses.town_or_city%TYPE;
1553: l_postal_code per_addresses.postal_code%TYPE;
1554: l_country per_addresses.country%TYPE; --R
1555:
1556:
1557: --person details

Line 1554: l_country per_addresses.country%TYPE; --R

1550: l_address_line3 per_addresses.address_line3%TYPE;
1551: l_address_line4 per_addresses.address_line3%TYPE;
1552: l_town_or_city per_addresses.town_or_city%TYPE;
1553: l_postal_code per_addresses.postal_code%TYPE;
1554: l_country per_addresses.country%TYPE; --R
1555:
1556:
1557: --person details
1558: l_last_name per_people_f.last_name%TYPE;