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_ARCHIVER_REPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 178: l_state_ein hr_organization_information.org_information3%type;

174: ,pv_state_id in varchar2)
175: RETURN VARCHAR2
176: IS
177:
178: l_state_ein hr_organization_information.org_information3%type;
179:
180: BEGIN
181:
182: SELECT hoi.org_information3

Line 184: FROM hr_organization_information hoi,

180: BEGIN
181:
182: SELECT hoi.org_information3
183: INTO l_state_ein
184: FROM hr_organization_information hoi,
185: pay_us_states pus
186: WHERE pus.state_code = pv_state_id
187: and hoi.organization_id = pv_tax_unit_id
188: and hoi.org_information_context = 'State Tax Rules'

Line 1246: lv_fed_ein hr_organization_information.org_information2%type;

1242: lv_state varchar2(150);
1243: lv_postal_code varchar2(150);
1244: lv_country varchar2(150);
1245: lv_gre_name hr_all_organization_units.name%type;
1246: lv_fed_ein hr_organization_information.org_information2%type;
1247: lv_org_name hr_all_organization_units.name%type;
1248: lv_location_code hr_locations_all.location_code%type;
1249: lv_action_type varchar2(150);
1250: