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_TERMS_QA_PVT dependencies on PER_ALL_PEOPLE_F

Line 1133: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl

1129: AND DOCUMENT_ID = P_DOC_ID
1130: AND CONTRACT_ADMIN_ID IS NOT NULL;
1131:
1132: CURSOR contract_admin_emp is
1133: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
1134: WHERE USG.DOCUMENT_TYPE = P_DOC_TYPE
1135: AND USG.DOCUMENT_ID = P_DOC_ID
1136: AND USG.CONTRACT_ADMIN_ID IS NOT NULL
1137: AND USG.contract_admin_id = ctrtadm.user_id

Line 1142: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl

1138: AND ctrtadm.employee_id = adminppl.person_id
1139: and rownum < 2;
1140:
1141: CURSOR contract_admin_valid_emp is
1142: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
1143: WHERE USG.DOCUMENT_TYPE = P_DOC_TYPE
1144: AND USG.DOCUMENT_ID = P_DOC_ID
1145: AND USG.CONTRACT_ADMIN_ID IS NOT NULL
1146: AND USG.contract_admin_id = ctrtadm.user_id