DBA Data[Home] [Help]

APPS.AHL_APPROVALS_PVT dependencies on FND_USER

Line 3241: FND_USER USR

3237: CURSOR c_approver_id_user (approver_name IN VARCHAR2)
3238: IS
3239: SELECT AJREV.RESOURCE_ID
3240: FROM JTF_RS_RESOURCE_EXTNS AJREV,
3241: FND_USER USR
3242: WHERE AJREV.CATEGORY IN ('EMPLOYEE','PARTNER', 'PARTY')
3243: AND AJREV.RESOURCE_ID > 0
3244: AND USR.USER_NAME LIKE UPPER(approver_name)
3245: AND AJREV.USER_ID = USR.USER_ID;