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

Line 173: l_address_line_1 hr_locations.address_line_1%TYPE ;

169: l_Record_code VARCHAR2(240) :=' ';
170: l_tax_payer_name hr_organization_units.name%TYPE ;
171: l_le_name hr_organization_units.name%TYPE ;
172: l_lu_name hr_organization_units.name%TYPE ;
173: l_address_line_1 hr_locations.address_line_1%TYPE ;
174: l_address_line_2 hr_locations.address_line_2%TYPE ;
175: l_address_line_3 hr_locations.address_line_3%TYPE ;
176: l_postal_code hr_locations.postal_code%TYPE ;
177: l_town_or_city hr_locations.town_or_city%TYPE ;

Line 174: l_address_line_2 hr_locations.address_line_2%TYPE ;

170: l_tax_payer_name hr_organization_units.name%TYPE ;
171: l_le_name hr_organization_units.name%TYPE ;
172: l_lu_name hr_organization_units.name%TYPE ;
173: l_address_line_1 hr_locations.address_line_1%TYPE ;
174: l_address_line_2 hr_locations.address_line_2%TYPE ;
175: l_address_line_3 hr_locations.address_line_3%TYPE ;
176: l_postal_code hr_locations.postal_code%TYPE ;
177: l_town_or_city hr_locations.town_or_city%TYPE ;
178: l_country hr_locations.country%TYPE ;

Line 175: l_address_line_3 hr_locations.address_line_3%TYPE ;

171: l_le_name hr_organization_units.name%TYPE ;
172: l_lu_name hr_organization_units.name%TYPE ;
173: l_address_line_1 hr_locations.address_line_1%TYPE ;
174: l_address_line_2 hr_locations.address_line_2%TYPE ;
175: l_address_line_3 hr_locations.address_line_3%TYPE ;
176: l_postal_code hr_locations.postal_code%TYPE ;
177: l_town_or_city hr_locations.town_or_city%TYPE ;
178: l_country hr_locations.country%TYPE ;
179: l_business_id hr_organization_information.org_information1%TYPE ;

Line 176: l_postal_code hr_locations.postal_code%TYPE ;

172: l_lu_name hr_organization_units.name%TYPE ;
173: l_address_line_1 hr_locations.address_line_1%TYPE ;
174: l_address_line_2 hr_locations.address_line_2%TYPE ;
175: l_address_line_3 hr_locations.address_line_3%TYPE ;
176: l_postal_code hr_locations.postal_code%TYPE ;
177: l_town_or_city hr_locations.town_or_city%TYPE ;
178: l_country hr_locations.country%TYPE ;
179: l_business_id hr_organization_information.org_information1%TYPE ;
180: l_Sal_subject_Wt NUMBER;

Line 177: l_town_or_city hr_locations.town_or_city%TYPE ;

173: l_address_line_1 hr_locations.address_line_1%TYPE ;
174: l_address_line_2 hr_locations.address_line_2%TYPE ;
175: l_address_line_3 hr_locations.address_line_3%TYPE ;
176: l_postal_code hr_locations.postal_code%TYPE ;
177: l_town_or_city hr_locations.town_or_city%TYPE ;
178: l_country hr_locations.country%TYPE ;
179: l_business_id hr_organization_information.org_information1%TYPE ;
180: l_Sal_subject_Wt NUMBER;
181: l_Sal_subject_Ts NUMBER;

Line 178: l_country hr_locations.country%TYPE ;

174: l_address_line_2 hr_locations.address_line_2%TYPE ;
175: l_address_line_3 hr_locations.address_line_3%TYPE ;
176: l_postal_code hr_locations.postal_code%TYPE ;
177: l_town_or_city hr_locations.town_or_city%TYPE ;
178: l_country hr_locations.country%TYPE ;
179: l_business_id hr_organization_information.org_information1%TYPE ;
180: l_Sal_subject_Wt NUMBER;
181: l_Sal_subject_Ts NUMBER;
182: l_Pay_subject_Wt NUMBER;

Line 308: , hr_locations hoi1

304: IS
305: SELECT hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
306: hoi1.POSTAL_CODE , hoi1.TOWN_OR_CITY , hoi1.COUNTRY
307: FROM hr_organization_units o1
308: , hr_locations hoi1
309: ,hr_organization_information hoi2
310: WHERE o1.business_group_id = l_business_group_id
311: AND hoi1.location_id = o1.location_id
312: AND hoi2.organization_id = o1.organization_id

Line 324: , hr_locations hoi1

320: IS
321: SELECT hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
322: hoi1.POSTAL_CODE , hoi1.TOWN_OR_CITY , hoi1.COUNTRY
323: FROM hr_organization_units o1
324: , hr_locations hoi1
325: ,hr_organization_information hoi2
326: WHERE o1.business_group_id = l_business_group_id
327: AND hoi1.location_id = o1.location_id
328: AND hoi2.organization_id = o1.organization_id