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

Line 139: l_address_line1 per_addresses.address_line1%TYPE;

135: IS
136: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_address_rec';
137: l_arch BOOLEAN;
138: --address details
139: l_address_line1 per_addresses.address_line1%TYPE;
140: l_address_line2 per_addresses.address_line2%TYPE;
141: l_address_line3 per_addresses.address_line3%TYPE;
142: l_address_line4 per_addresses.address_line3%TYPE;
143:

Line 140: l_address_line2 per_addresses.address_line2%TYPE;

136: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_address_rec';
137: l_arch BOOLEAN;
138: --address details
139: l_address_line1 per_addresses.address_line1%TYPE;
140: l_address_line2 per_addresses.address_line2%TYPE;
141: l_address_line3 per_addresses.address_line3%TYPE;
142: l_address_line4 per_addresses.address_line3%TYPE;
143:
144: CURSOR csr_address

Line 141: l_address_line3 per_addresses.address_line3%TYPE;

137: l_arch BOOLEAN;
138: --address details
139: l_address_line1 per_addresses.address_line1%TYPE;
140: l_address_line2 per_addresses.address_line2%TYPE;
141: l_address_line3 per_addresses.address_line3%TYPE;
142: l_address_line4 per_addresses.address_line3%TYPE;
143:
144: CURSOR csr_address
145: IS

Line 142: l_address_line4 per_addresses.address_line3%TYPE;

138: --address details
139: l_address_line1 per_addresses.address_line1%TYPE;
140: l_address_line2 per_addresses.address_line2%TYPE;
141: l_address_line3 per_addresses.address_line3%TYPE;
142: l_address_line4 per_addresses.address_line3%TYPE;
143:
144: CURSOR csr_address
145: IS
146: SELECT upper(SUBSTR(trim(addr.address_line1),1,35)) addr1,

Line 152: FROM per_addresses addr

148: upper(SUBSTR(trim(addr.address_line3),1,35)) addr3,
149: SUBSTR(addr.postal_code,1,10) post_code,
150: upper(SUBSTR(trim(addr.town_or_city),1,35)) addr4,
151: upper(SUBSTR(trim(addr.country),1,35)) country
152: FROM per_addresses addr
153: WHERE addr.person_id = p_person_id
154: AND ( addr.primary_flag = 'Y'
155: OR addr.primary_flag IS NULL)
156: AND p_effective_date