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.OKC_REP_UTIL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1329: FROM hr_all_organization_units

1325: AND document_type_class = 'REPOSITORY';
1326:
1327: CURSOR internal_party_exist_csr IS
1328: SELECT organization_id
1329: FROM hr_all_organization_units
1330: WHERE UPPER(name) = UPPER(p_party_name);
1331:
1332: CURSOR tca_party_exist_csr IS
1333: SELECT party_id

Line 1366: FROM hr_all_organization_units

1362: AND party_role_code = p_party_role_code;
1363:
1364: CURSOR internal_party_and_role_csr IS
1365: SELECT 1
1366: FROM hr_all_organization_units
1367: WHERE UPPER(name) = UPPER(p_party_name)
1368: AND organization_id = p_party_id;
1369:
1370: CURSOR tca_party_and_role_csr IS

Line 1772: 'Party with id' || p_party_id || ' and name ' || p_party_name || 'not found in table HR_ALL_ORGANIZATION_UNITS');

1768: IF internal_party_and_role_csr%NOTFOUND THEN
1769:
1770: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1771: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1772: 'Party with id' || p_party_id || ' and name ' || p_party_name || 'not found in table HR_ALL_ORGANIZATION_UNITS');
1773: END IF;
1774:
1775: CLOSE internal_party_and_role_csr;
1776:

Line 3727: FROM HR_ALL_ORGANIZATION_UNITS

3723: AND bus_doc.document_type_class = 'REPOSITORY';
3724:
3725: CURSOR ORG_NAME_CSR (p_org_name VARCHAR2) IS
3726: SELECT ORGANIZATION_ID
3727: FROM HR_ALL_ORGANIZATION_UNITS
3728: WHERE UPPER(NAME) = UPPER(p_org_name)
3729: AND mo_global.check_access(ORGANIZATION_ID) = 'Y';
3730:
3731: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS