DBA Data[Home] [Help]

APPS.EAM_REQUEST_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 221: FROM WIP_DISCRETE_JOBS wdj

217: IF p_eam_request_rec.transaction_type = 1 AND p_eam_request_rec.request_type =1 THEN
218: begin
219: SELECT 1
220: INTO g_dummy
221: FROM WIP_DISCRETE_JOBS wdj
222: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
223: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
224: AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;
225:

Line 252: FROM WIP_DISCRETE_JOBS wdj

248: IF p_eam_request_rec.transaction_type = 1 AND p_eam_request_rec.request_type =2 THEN
249: begin
250: SELECT 1
251: INTO g_dummy
252: FROM WIP_DISCRETE_JOBS wdj
253: WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
254: WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
255: AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;
256: