[Home] [Help]
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
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: and transaction_type = 1
263: and wip_entity_id = p_wip_entity_id; -- added txn type and wipId clauses for bug 16532823
264: END Calculate_Actl_Dates;