APPS.EAM_PM_UTILS dependencies on EAM_JOB_COMPLETION_TXNS

Line 156: eam_job_completion_txns ejct

152:
153: select max(ejct.actual_end_date)
154: into l_last_actual_end_date
155: from
156: eam_job_completion_txns ejct
157: where
158: transaction_type=1
159: and transaction_id in
160: (select max(ejct.transaction_id) from

Line 161: eam_job_completion_txns ejct,

157: where
158: transaction_type=1
159: and transaction_id in
160: (select max(ejct.transaction_id) from
161: eam_job_completion_txns ejct,
162: wip_discrete_jobs wdj1,
163: wip_discrete_jobs wdj2
164: where wdj1.wip_entity_id=p_wip_entity_id
165: and wdj1.maintenance_object_type = wdj2.maintenance_object_type

Line 181: from eam_job_completion_txns

177: -- p_wip_entity_id and if it is a "completion" transaction.
178:
179: select wip_entity_id, transaction_type
180: into l_last_wip_entity_id, l_transaction_type
181: from eam_job_completion_txns
182: where actual_end_date=l_last_actual_end_date
183: and transaction_id=
184: (select max(transaction_id)
185: from eam_job_completion_txns

Line 185: from eam_job_completion_txns

181: from eam_job_completion_txns
182: where actual_end_date=l_last_actual_end_date
183: and transaction_id=
184: (select max(transaction_id)
185: from eam_job_completion_txns
186: where wip_entity_id=p_wip_entity_id
187: and transaction_type = 1);
188:
189: if (p_wip_entity_id <> l_last_wip_entity_id)