DBA Data[Home] [Help]

APPS.OKC_TERMS_QA_PVT dependencies on FND_USER

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

1139: -- Fix for 13435490 end
1140:
1141:
1142: CURSOR contract_admin_emp is
1143: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
1144: WHERE USG.DOCUMENT_TYPE = P_DOC_TYPE
1145: AND USG.DOCUMENT_ID = P_DOC_ID
1146: AND USG.CONTRACT_ADMIN_ID IS NOT NULL
1147: AND USG.contract_admin_id = ctrtadm.user_id

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

1148: AND ctrtadm.employee_id = adminppl.person_id
1149: and rownum < 2;
1150:
1151: CURSOR contract_admin_valid_emp is
1152: SELECT 'Y' FROM OKC_TEMPLATE_USAGES USG, fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
1153: WHERE USG.DOCUMENT_TYPE = P_DOC_TYPE
1154: AND USG.DOCUMENT_ID = P_DOC_ID
1155: AND USG.CONTRACT_ADMIN_ID IS NOT NULL
1156: AND USG.contract_admin_id = ctrtadm.user_id