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

Line 1176: hr_organization_information hoi

1172:
1173: CURSOR c_currency_code is
1174: select hoi.org_information10
1175: from hr_organization_units hou,
1176: hr_organization_information hoi
1177: where hou.organization_id = p_business_group_id /* Bug 3487250 */
1178: and hou.organization_id = hoi.organization_id
1179: and hoi.org_information_context = 'Business Group Information';
1180:

Line 1271: from hr_organization_information

1267: and lei_information1 = upper(p_doc_type);
1268:
1269: CURSOR get_org_eit (l_organization_id number) IS
1270: select org_information2,org_information3
1271: from hr_organization_information
1272: where org_information_context = 'HR_SELF_SERVICE_ORG_PREFERENCE'
1273: and org_information1 = upper(p_doc_type)
1274: and organization_id = l_organization_id;
1275:

Line 1278: from hr_organization_information hoi

1274: and organization_id = l_organization_id;
1275:
1276: CURSOR get_bg_eit (l_business_group_id number) IS
1277: select org_information2, org_information3
1278: from hr_organization_information hoi
1279: where hoi.organization_id = l_business_group_id
1280: and hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
1281: and hoi.org_information1 = upper(p_doc_type) ;
1282:

Line 1648: hr_organization_information

1644: CURSOR cur_legislation_code is
1645: select
1646: org_information9
1647: from
1648: hr_organization_information
1649: where
1650: org_information_context = 'Business Group Information'
1651: and organization_id = p_business_group_id;
1652:

Line 1653: l_legislation_code hr_organization_information.org_information9%TYPE;

1649: where
1650: org_information_context = 'Business Group Information'
1651: and organization_id = p_business_group_id;
1652:
1653: l_legislation_code hr_organization_information.org_information9%TYPE;
1654:
1655: BEGIN
1656:
1657: OPEN cur_legislation_code;

Line 1883: from hr_organization_information hoi

1879: RETURN VARCHAR2 IS
1880:
1881: cursor cur_legislation(p_business_grp_id in number) is
1882: select hoi.org_information9
1883: from hr_organization_information hoi
1884: where hoi.organization_id = p_business_grp_id
1885: and hoi.org_information_context = 'Business Group Information';
1886:
1887: cursor cur_payment_typ(p_legislation_code in varchar2