APPS.EAM_MATERIALISSUE_PVT dependencies on DUAL

Line 597: DUAL;

593: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
594: SELECT
595: wip_job_number_s.nextval INTO l_rebuild_job_temp
596: FROM
597: DUAL;
598:
599: l_rebuild_job_name:= l_rebuild_job_temp ;
600: else
601: l_rebuild_job_name := p_rebuild_job_name;

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

803: acct_period_id = l_acct_period_id
804: where transaction_temp_id = p_trx_tmp_id;
805: /* Added for bug 4041420 - End */
806:
807: select mtl_material_transactions_s.nextval into l_header_id from dual;
808: update mtl_material_transactions_temp
809: set transaction_header_id = l_header_id,
810: transaction_status = null, --Added since WIP is no longer doing this in 11.5.10
811: primary_quantity = -1* primary_quantity,

Line 960: DUAL;

956: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
957: SELECT
958: wip_job_number_s.nextval INTO l_rebuild_job_temp
959: FROM
960: DUAL;
961:
962: l_rebuild_job_name:= l_rebuild_job_temp ;
963: else
964: l_rebuild_job_name :=p_rebuild_job_name;