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_NO_ARCHIVE_RSEA dependencies on HR_LOCATIONS

Line 159: l_address_line_1 hr_locations.address_line_1%TYPE ;

155: l_industry_status hr_organization_information.org_information1%TYPE ;
156: l_tax_office_name hr_organization_units.name%TYPE ;
157: l_tax_office_id hr_organization_information.organization_id%TYPE ;
158:
159: l_address_line_1 hr_locations.address_line_1%TYPE ;
160: l_address_line_2 hr_locations.address_line_2%TYPE ;
161: l_address_line_3 hr_locations.address_line_3%TYPE ;
162: l_postal_code hr_locations.postal_code%TYPE ;
163: l_postal_office hr_locations.postal_code%TYPE ;

Line 160: l_address_line_2 hr_locations.address_line_2%TYPE ;

156: l_tax_office_name hr_organization_units.name%TYPE ;
157: l_tax_office_id hr_organization_information.organization_id%TYPE ;
158:
159: l_address_line_1 hr_locations.address_line_1%TYPE ;
160: l_address_line_2 hr_locations.address_line_2%TYPE ;
161: l_address_line_3 hr_locations.address_line_3%TYPE ;
162: l_postal_code hr_locations.postal_code%TYPE ;
163: l_postal_office hr_locations.postal_code%TYPE ;
164:

Line 161: l_address_line_3 hr_locations.address_line_3%TYPE ;

157: l_tax_office_id hr_organization_information.organization_id%TYPE ;
158:
159: l_address_line_1 hr_locations.address_line_1%TYPE ;
160: l_address_line_2 hr_locations.address_line_2%TYPE ;
161: l_address_line_3 hr_locations.address_line_3%TYPE ;
162: l_postal_code hr_locations.postal_code%TYPE ;
163: l_postal_office hr_locations.postal_code%TYPE ;
164:
165: l_phone hr_organization_information.org_information1%TYPE ;

Line 162: l_postal_code hr_locations.postal_code%TYPE ;

158:
159: l_address_line_1 hr_locations.address_line_1%TYPE ;
160: l_address_line_2 hr_locations.address_line_2%TYPE ;
161: l_address_line_3 hr_locations.address_line_3%TYPE ;
162: l_postal_code hr_locations.postal_code%TYPE ;
163: l_postal_office hr_locations.postal_code%TYPE ;
164:
165: l_phone hr_organization_information.org_information1%TYPE ;
166: l_email hr_organization_information.org_information1%TYPE ;

Line 163: l_postal_office hr_locations.postal_code%TYPE ;

159: l_address_line_1 hr_locations.address_line_1%TYPE ;
160: l_address_line_2 hr_locations.address_line_2%TYPE ;
161: l_address_line_3 hr_locations.address_line_3%TYPE ;
162: l_postal_code hr_locations.postal_code%TYPE ;
163: l_postal_office hr_locations.postal_code%TYPE ;
164:
165: l_phone hr_organization_information.org_information1%TYPE ;
166: l_email hr_organization_information.org_information1%TYPE ;
167:

Line 168: l_taddress_line_1 hr_locations.address_line_1%TYPE ;

164:
165: l_phone hr_organization_information.org_information1%TYPE ;
166: l_email hr_organization_information.org_information1%TYPE ;
167:
168: l_taddress_line_1 hr_locations.address_line_1%TYPE ;
169: l_taddress_line_2 hr_locations.address_line_2%TYPE ;
170: l_taddress_line_3 hr_locations.address_line_3%TYPE ;
171: l_tpostal_code hr_locations.postal_code%TYPE ;
172: l_tpostal_office hr_locations.postal_code%TYPE ;

Line 169: l_taddress_line_2 hr_locations.address_line_2%TYPE ;

165: l_phone hr_organization_information.org_information1%TYPE ;
166: l_email hr_organization_information.org_information1%TYPE ;
167:
168: l_taddress_line_1 hr_locations.address_line_1%TYPE ;
169: l_taddress_line_2 hr_locations.address_line_2%TYPE ;
170: l_taddress_line_3 hr_locations.address_line_3%TYPE ;
171: l_tpostal_code hr_locations.postal_code%TYPE ;
172: l_tpostal_office hr_locations.postal_code%TYPE ;
173:

Line 170: l_taddress_line_3 hr_locations.address_line_3%TYPE ;

166: l_email hr_organization_information.org_information1%TYPE ;
167:
168: l_taddress_line_1 hr_locations.address_line_1%TYPE ;
169: l_taddress_line_2 hr_locations.address_line_2%TYPE ;
170: l_taddress_line_3 hr_locations.address_line_3%TYPE ;
171: l_tpostal_code hr_locations.postal_code%TYPE ;
172: l_tpostal_office hr_locations.postal_code%TYPE ;
173:
174: l_reporting_start_date DATE;

Line 171: l_tpostal_code hr_locations.postal_code%TYPE ;

167:
168: l_taddress_line_1 hr_locations.address_line_1%TYPE ;
169: l_taddress_line_2 hr_locations.address_line_2%TYPE ;
170: l_taddress_line_3 hr_locations.address_line_3%TYPE ;
171: l_tpostal_code hr_locations.postal_code%TYPE ;
172: l_tpostal_office hr_locations.postal_code%TYPE ;
173:
174: l_reporting_start_date DATE;
175: l_reporting_end_date DATE;

Line 172: l_tpostal_office hr_locations.postal_code%TYPE ;

168: l_taddress_line_1 hr_locations.address_line_1%TYPE ;
169: l_taddress_line_2 hr_locations.address_line_2%TYPE ;
170: l_taddress_line_3 hr_locations.address_line_3%TYPE ;
171: l_tpostal_code hr_locations.postal_code%TYPE ;
172: l_tpostal_office hr_locations.postal_code%TYPE ;
173:
174: l_reporting_start_date DATE;
175: l_reporting_end_date DATE;
176:

Line 290: , hr_locations hoi1

286: IS
287: SELECT hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
288: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) , LENGTH(hlu.MEANING) -(INSTR(hlu.MEANING,' ', 1,1) -1) ) POSTAL_OFFICE
289: FROM hr_organization_units o1
290: , hr_locations hoi1
291: ,hr_organization_information hoi2
292: ,hr_lookups hlu
293: WHERE o1.business_group_id = l_business_group_id
294: AND hoi1.location_id = o1.location_id

Line 313: , hr_locations hoi1

309: IS
310: SELECT o1.name , hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
311: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) ) POSTAL_OFFICE
312: FROM hr_organization_units o1
313: , hr_locations hoi1
314: ,hr_organization_information hoi2
315: ,hr_lookups hlu
316: WHERE o1.business_group_id = l_business_group_id
317: AND hoi1.location_id = o1.location_id