DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on FND_USER

Line 211: FROM FND_USER A

207: -- query for converting Employee/Recepient to employee_id
208: CURSOR DEFAULT_USER_CUR
209: IS
210: SELECT A.employee_id
211: FROM FND_USER A
212: WHERE USER_ID=FND_GLOBAL.USER_ID;
213:
214: -- Query for Disposition..
215:

Line 1341: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID

1337:
1338: END IF;
1339:
1340: --If (condition is unserviceable/MRB AND P_create_SR == 'Y' ) then
1341: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID
1342: --Call Service request API to create service request.
1343: --( AHL_NONROUTINE_JOB_PVT.process_nonroutine_job)
1344: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
1345: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type