DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on EAM_JOB_COMPLETION_TXNS

Line 256: from eam_job_completion_txns where transaction_type = 1

252: IF NOT p_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
253: return;
254: END IF;
255: select max(transaction_date) into l_max_tran_date
256: from eam_job_completion_txns where transaction_type = 1
257: and wip_entity_id = p_wip_entity_id;
258: select actual_start_date, actual_end_date into
259: x_actual_start_date, x_actual_end_date
260: from eam_job_completion_txns

Line 260: from eam_job_completion_txns

256: from eam_job_completion_txns where transaction_type = 1
257: and wip_entity_id = p_wip_entity_id;
258: select actual_start_date, actual_end_date into
259: x_actual_start_date, x_actual_end_date
260: from eam_job_completion_txns
261: where transaction_date = l_max_tran_date;
262: END Calculate_Actl_Dates;
263:
264: -- Validate: