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 222: l_state_ein hr_organization_information.org_information3%type;

218: ,pv_state_id in varchar2)
219: RETURN VARCHAR2
220: IS
221:
222: l_state_ein hr_organization_information.org_information3%type;
223:
224: BEGIN
225:
226: SELECT hoi.org_information3

Line 228: FROM hr_organization_information hoi,

224: BEGIN
225:
226: SELECT hoi.org_information3
227: INTO l_state_ein
228: FROM hr_organization_information hoi,
229: pay_us_states pus
230: WHERE pus.state_code = pv_state_id
231: and hoi.organization_id = pv_tax_unit_id
232: and hoi.org_information_context = 'State Tax Rules'

Line 1474: lv_fed_ein hr_organization_information.org_information2%type;

1470: lv_state varchar2(150);
1471: lv_postal_code varchar2(150);
1472: lv_country varchar2(150);
1473: lv_gre_name hr_all_organization_units.name%type;
1474: lv_fed_ein hr_organization_information.org_information2%type;
1475: lv_org_name hr_all_organization_units.name%type;
1476: lv_location_code hr_locations_all.location_code%type;
1477: lv_action_type varchar2(150);
1478: