DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on FND_USER

Line 222: FROM FND_USER A

218: -- query for converting Employee/Recepient to employee_id
219: CURSOR DEFAULT_USER_CUR
220: IS
221: SELECT A.employee_id
222: FROM FND_USER A
223: WHERE USER_ID=FND_GLOBAL.USER_ID;
224:
225: -- Query for Disposition..
226:

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

1626:
1627: END IF;
1628:
1629: --If (condition is unserviceable/MRB AND P_create_SR == 'Y' ) then
1630: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID
1631: --Call Service request API to create service request.
1632: --( AHL_NONROUTINE_JOB_PVT.process_nonroutine_job)
1633: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
1634: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type