APPS.CSE_DEPLOYMENT_GRP dependencies on DUAL

Line 790: FROM sys.dual;

786: debug(' capitalizable quantity : '||l_exp_item_rec.quantity);
787:
788: SELECT csi_pa_interface_s.nextval
789: INTO l_ref_sufix
790: FROM sys.dual;
791:
792: OPEN c_Business_Group_cur( ei_rec.org_id ) ;
793: FETCH c_Business_Group_cur INTO l_Business_Group_rec;
794: CLOSE c_Business_Group_cur;

Line 890: FROM sys.dual;

886: l_nl_pa_interface_tbl(i) := l_nl_pa_interface_tbl(i-1);
887:
888: SELECT csi_pa_interface_s.nextval
889: INTO l_ref_sufix
890: FROM sys.dual;
891:
892: SELECT segment1
893: INTO l_nl_pa_interface_tbl(i).project_number
894: FROM pa_projects_all

Line 949: FROM sys.dual;

945: i := i+1;
946: debug('Record found in pa_txn_intf_all ');
947: SELECT csi_pa_interface_s.nextval
948: INTO l_ref_sufix
949: FROM sys.dual;
950:
951: IF l_txn_intf_csr.transaction_source = 'CSE_PO_RECEIPT'
952: THEN
953: l_nl_pa_interface_tbl(i).vendor_number :=l_txn_intf_csr.vendor_number;

Line 1031: FROM sys.dual;

1027: l_nl_pa_interface_tbl(i) := l_nl_pa_interface_tbl(i-1);
1028:
1029: SELECT csi_pa_interface_s.nextval
1030: INTO l_ref_sufix
1031: FROM sys.dual;
1032:
1033: SELECT segment1
1034: INTO l_nl_pa_interface_tbl(i).project_number
1035: FROM pa_projects_all

Line 1178: SELECT sysdate INTO l_sysdate FROM sys.dual;

1174: csi_t_gen_utility_pvt.build_file_name(
1175: p_file_segment1 => 'cse',
1176: p_file_segment2 => to_char(sysdate, 'DDMONYYYY'));
1177:
1178: SELECT sysdate INTO l_sysdate FROM sys.dual;
1179:
1180: debug('Inside API cse_deployment_grp.process_transaction '||to_char(l_sysdate, 'dd-mon-yyyy hh24:mi:ss'));
1181: debug(' instance_tbl.count : '||p_instance_tbl.count);
1182: debug(' dest_loc_tbl.count : '||p_dest_location_tbl.count);