DBA Data[Home] [Help]

APPS.AHL_APPROVALS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 3240: FROM JTF_RS_RESOURCE_EXTNS AJREV,

3236:
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)

Line 3273: FROM JTF_RS_RESOURCE_EXTNS AJREV

3269: CURSOR c_approver_name_id_user (approver_name IN VARCHAR2,
3270: approver_id IN NUMBER)
3271: IS
3272: SELECT AJREV.RESOURCE_ID
3273: FROM JTF_RS_RESOURCE_EXTNS AJREV
3274: WHERE AJREV.CATEGORY IN ('EMPLOYEE','PARTNER', 'PARTY')
3275: AND AJREV.RESOURCE_ID > 0
3276: AND UPPER(AJREV.USER_NAME) LIKE UPPER(approver_name)
3277: AND AJREV.RESOURCE_ID = approver_id;