APPS.EAM_MATERIALISSUE_PVT dependencies on DUAL

Line 388: DUAL;

384: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
385: SELECT
386: wip_job_number_s.nextval INTO l_rebuild_job_temp
387: FROM
388: DUAL;
389:
390: l_rebuild_job_name:= l_rebuild_job_temp ;
391: else
392: l_rebuild_job_name := p_rebuild_job_name;

Line 580: select mtl_material_transactions_s.nextval into l_header_id from dual;

576: acct_period_id = l_acct_period_id
577: where transaction_temp_id = p_trx_tmp_id;
578: /* Added for bug 4041420 - End */
579:
580: select mtl_material_transactions_s.nextval into l_header_id from dual;
581: update mtl_material_transactions_temp
582: set transaction_header_id = l_header_id,
583: transaction_status = null, --Added since WIP is no longer doing this in 11.5.10
584: primary_quantity = -1* primary_quantity,

Line 733: DUAL;

729: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
730: SELECT
731: wip_job_number_s.nextval INTO l_rebuild_job_temp
732: FROM
733: DUAL;
734:
735: l_rebuild_job_name:= l_rebuild_job_temp ;
736: else
737: l_rebuild_job_name :=p_rebuild_job_name;