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

Line 1235: hr_organization_information hoi

1231: start with pose.organization_id_child = p_emp_org_id
1232: and pose.org_structure_version_id = p_version
1233: connect by prior pose.organization_id_parent = organization_id_child
1234: ) org,
1235: hr_organization_information hoi
1236: where hoi.organization_id = org.organization_id_parent
1237: and hoi.org_information1 = p_target_year
1238: and hoi.org_information_context = 'KR_YEA_ENTRY_PERIOD_ORG'
1239: group by organization_id_child, org.hierarchy_level

Line 1247: from hr_organization_information hoi

1243: cursor csr_bg_entry_period is
1244: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1245: max(fnd_date.canonical_to_date(hoi.org_information3)),
1246: max(fnd_date.canonical_to_date(hoi.org_information4))
1247: from hr_organization_information hoi
1248: where hoi.organization_id = p_business_group_id
1249: and hoi.org_information1 = p_target_year
1250: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_BG';
1251:

Line 1257: from hr_organization_information hoi

1253: cursor csr_emp_org_entry_period (p_emp_org number) is
1254: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1255: max(fnd_date.canonical_to_date(hoi.org_information3)),
1256: max(fnd_date.canonical_to_date(hoi.org_information4))
1257: from hr_organization_information hoi
1258: where hoi.organization_id = p_emp_org
1259: and hoi.org_information1 = p_target_year
1260: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_ORG';
1261: