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

Line 209: l_address_line1 per_addresses.address_line1%TYPE;

205:
206: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_address_rec';
207: l_arch boolean;
208: --Address Details
209: l_address_line1 per_addresses.address_line1%TYPE;
210: l_address_line2 per_addresses.address_line2%TYPE;
211: l_address_line3 per_addresses.address_line3%TYPE;
212: l_address_line4 per_addresses.address_line3%TYPE;
213:

Line 210: l_address_line2 per_addresses.address_line2%TYPE;

206: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_address_rec';
207: l_arch boolean;
208: --Address Details
209: l_address_line1 per_addresses.address_line1%TYPE;
210: l_address_line2 per_addresses.address_line2%TYPE;
211: l_address_line3 per_addresses.address_line3%TYPE;
212: l_address_line4 per_addresses.address_line3%TYPE;
213:
214: cursor csr_address is

Line 211: l_address_line3 per_addresses.address_line3%TYPE;

207: l_arch boolean;
208: --Address Details
209: l_address_line1 per_addresses.address_line1%TYPE;
210: l_address_line2 per_addresses.address_line2%TYPE;
211: l_address_line3 per_addresses.address_line3%TYPE;
212: l_address_line4 per_addresses.address_line3%TYPE;
213:
214: cursor csr_address is
215: select upper(substr(trim(addr.address_line1),1,35)) addr1,

Line 212: l_address_line4 per_addresses.address_line3%TYPE;

208: --Address Details
209: l_address_line1 per_addresses.address_line1%TYPE;
210: l_address_line2 per_addresses.address_line2%TYPE;
211: l_address_line3 per_addresses.address_line3%TYPE;
212: l_address_line4 per_addresses.address_line3%TYPE;
213:
214: cursor csr_address is
215: select upper(substr(trim(addr.address_line1),1,35)) addr1,
216: upper(substr(trim(addr.address_line2),1,35)) addr2,

Line 221: from per_addresses addr

217: upper(substr(trim(addr.address_line3),1,35)) addr3,
218: substr(addr.postal_code,1,10) post_code,
219: upper(substr(trim(addr.town_or_city),1,35)) addr4,
220: upper(substr(trim(addr.country),1,35)) country
221: from per_addresses addr
222: where addr.person_id = p_person_id
223: and ( addr.primary_flag = 'Y'
224: or addr.primary_flag is null)
225: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))

Line 864: l_address_line1 per_addresses.address_line1%TYPE;

860:
861: l_assignment_number per_assignments_f.assignment_number%TYPE;
862:
863: --address details
864: l_address_line1 per_addresses.address_line1%TYPE;
865: l_address_line2 per_addresses.address_line2%TYPE;
866: l_address_line3 per_addresses.address_line3%TYPE;
867: l_address_line4 per_addresses.address_line3%TYPE;
868: l_town_or_city per_addresses.town_or_city%TYPE;

Line 865: l_address_line2 per_addresses.address_line2%TYPE;

861: l_assignment_number per_assignments_f.assignment_number%TYPE;
862:
863: --address details
864: l_address_line1 per_addresses.address_line1%TYPE;
865: l_address_line2 per_addresses.address_line2%TYPE;
866: l_address_line3 per_addresses.address_line3%TYPE;
867: l_address_line4 per_addresses.address_line3%TYPE;
868: l_town_or_city per_addresses.town_or_city%TYPE;
869: l_postal_code per_addresses.postal_code%TYPE;

Line 866: l_address_line3 per_addresses.address_line3%TYPE;

862:
863: --address details
864: l_address_line1 per_addresses.address_line1%TYPE;
865: l_address_line2 per_addresses.address_line2%TYPE;
866: l_address_line3 per_addresses.address_line3%TYPE;
867: l_address_line4 per_addresses.address_line3%TYPE;
868: l_town_or_city per_addresses.town_or_city%TYPE;
869: l_postal_code per_addresses.postal_code%TYPE;
870: l_country per_addresses.country%TYPE; --R

Line 867: l_address_line4 per_addresses.address_line3%TYPE;

863: --address details
864: l_address_line1 per_addresses.address_line1%TYPE;
865: l_address_line2 per_addresses.address_line2%TYPE;
866: l_address_line3 per_addresses.address_line3%TYPE;
867: l_address_line4 per_addresses.address_line3%TYPE;
868: l_town_or_city per_addresses.town_or_city%TYPE;
869: l_postal_code per_addresses.postal_code%TYPE;
870: l_country per_addresses.country%TYPE; --R
871:

Line 868: l_town_or_city per_addresses.town_or_city%TYPE;

864: l_address_line1 per_addresses.address_line1%TYPE;
865: l_address_line2 per_addresses.address_line2%TYPE;
866: l_address_line3 per_addresses.address_line3%TYPE;
867: l_address_line4 per_addresses.address_line3%TYPE;
868: l_town_or_city per_addresses.town_or_city%TYPE;
869: l_postal_code per_addresses.postal_code%TYPE;
870: l_country per_addresses.country%TYPE; --R
871:
872:

Line 869: l_postal_code per_addresses.postal_code%TYPE;

865: l_address_line2 per_addresses.address_line2%TYPE;
866: l_address_line3 per_addresses.address_line3%TYPE;
867: l_address_line4 per_addresses.address_line3%TYPE;
868: l_town_or_city per_addresses.town_or_city%TYPE;
869: l_postal_code per_addresses.postal_code%TYPE;
870: l_country per_addresses.country%TYPE; --R
871:
872:
873: --person details

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

866: l_address_line3 per_addresses.address_line3%TYPE;
867: l_address_line4 per_addresses.address_line3%TYPE;
868: l_town_or_city per_addresses.town_or_city%TYPE;
869: l_postal_code per_addresses.postal_code%TYPE;
870: l_country per_addresses.country%TYPE; --R
871:
872:
873: --person details
874: l_last_name per_people_f.last_name%TYPE;

Line 1079: l_address_line1 per_addresses.address_line1%TYPE;

1075:
1076: l_assignment_number per_assignments_f.assignment_number%TYPE;
1077:
1078: --address details
1079: l_address_line1 per_addresses.address_line1%TYPE;
1080: l_address_line2 per_addresses.address_line2%TYPE;
1081: l_address_line3 per_addresses.address_line3%TYPE;
1082: l_address_line4 per_addresses.address_line3%TYPE;
1083: l_town_or_city per_addresses.town_or_city%TYPE;

Line 1080: l_address_line2 per_addresses.address_line2%TYPE;

1076: l_assignment_number per_assignments_f.assignment_number%TYPE;
1077:
1078: --address details
1079: l_address_line1 per_addresses.address_line1%TYPE;
1080: l_address_line2 per_addresses.address_line2%TYPE;
1081: l_address_line3 per_addresses.address_line3%TYPE;
1082: l_address_line4 per_addresses.address_line3%TYPE;
1083: l_town_or_city per_addresses.town_or_city%TYPE;
1084: l_postal_code per_addresses.postal_code%TYPE;

Line 1081: l_address_line3 per_addresses.address_line3%TYPE;

1077:
1078: --address details
1079: l_address_line1 per_addresses.address_line1%TYPE;
1080: l_address_line2 per_addresses.address_line2%TYPE;
1081: l_address_line3 per_addresses.address_line3%TYPE;
1082: l_address_line4 per_addresses.address_line3%TYPE;
1083: l_town_or_city per_addresses.town_or_city%TYPE;
1084: l_postal_code per_addresses.postal_code%TYPE;
1085: l_country per_addresses.country%TYPE; --R

Line 1082: l_address_line4 per_addresses.address_line3%TYPE;

1078: --address details
1079: l_address_line1 per_addresses.address_line1%TYPE;
1080: l_address_line2 per_addresses.address_line2%TYPE;
1081: l_address_line3 per_addresses.address_line3%TYPE;
1082: l_address_line4 per_addresses.address_line3%TYPE;
1083: l_town_or_city per_addresses.town_or_city%TYPE;
1084: l_postal_code per_addresses.postal_code%TYPE;
1085: l_country per_addresses.country%TYPE; --R
1086:

Line 1083: l_town_or_city per_addresses.town_or_city%TYPE;

1079: l_address_line1 per_addresses.address_line1%TYPE;
1080: l_address_line2 per_addresses.address_line2%TYPE;
1081: l_address_line3 per_addresses.address_line3%TYPE;
1082: l_address_line4 per_addresses.address_line3%TYPE;
1083: l_town_or_city per_addresses.town_or_city%TYPE;
1084: l_postal_code per_addresses.postal_code%TYPE;
1085: l_country per_addresses.country%TYPE; --R
1086:
1087:

Line 1084: l_postal_code per_addresses.postal_code%TYPE;

1080: l_address_line2 per_addresses.address_line2%TYPE;
1081: l_address_line3 per_addresses.address_line3%TYPE;
1082: l_address_line4 per_addresses.address_line3%TYPE;
1083: l_town_or_city per_addresses.town_or_city%TYPE;
1084: l_postal_code per_addresses.postal_code%TYPE;
1085: l_country per_addresses.country%TYPE; --R
1086:
1087:
1088: --person details

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

1081: l_address_line3 per_addresses.address_line3%TYPE;
1082: l_address_line4 per_addresses.address_line3%TYPE;
1083: l_town_or_city per_addresses.town_or_city%TYPE;
1084: l_postal_code per_addresses.postal_code%TYPE;
1085: l_country per_addresses.country%TYPE; --R
1086:
1087:
1088: --person details
1089: l_last_name per_people_f.last_name%TYPE;