APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on DUAL

Line 222: FROM sys.dual;

218: BEGIN
219:
220: SELECT csi_pa_interface_s.nextval
221: INTO l_ref_suffix_inner -- Changes for bug 7368371
222: FROM sys.dual;
223:
224: x_nl_pa_interface_rec.transaction_source := p_ei_rec.transaction_source;
225: x_nl_pa_interface_rec.batch_name := p_in_srv_pa_attr_rec.transaction_id;
226: x_nl_pa_interface_rec.expenditure_ending_date := p_ei_rec.expenditure_ending_date;

Line 488: FROM sys.dual;

484: debug(' capitalizable quantity : '||l_exp_item_rec.quantity);
485:
486: SELECT csi_pa_interface_s.nextval
487: INTO l_ref_sufix
488: FROM sys.dual;
489:
490: l_nl_pa_interface_tbl(i).transaction_source := ei_rec.transaction_source;
491: l_nl_pa_interface_tbl(i).batch_name := p_in_srv_pa_attr_rec.transaction_id;
492: l_nl_pa_interface_tbl(i).expenditure_ending_date := ei_rec.expenditure_ending_date;

Line 578: FROM sys.dual;

574: l_nl_pa_interface_tbl(i) := l_nl_pa_interface_tbl(i-1);
575:
576: SELECT csi_pa_interface_s.nextval
577: INTO l_ref_sufix
578: FROM sys.dual;
579:
580: l_nl_pa_interface_tbl(i).orig_transaction_reference := p_in_srv_pa_attr_rec.transaction_id;
581: l_nl_pa_interface_tbl(i).attribute8 := null;
582: l_nl_pa_interface_tbl(i).attribute9 := null;