APPS.CSE_COST_COLLECTOR dependencies on DUAL

Line 158: FROM sys.dual;

154: AND oap.acct_period_id = l_acct_period_id;
155:
156: CURSOR c_costing IS
157: SELECT NVL(FND_PROFILE.VALUE('CSE_EIB_COSTING_USED'),'Y')
158: FROM sys.dual;
159:
160: l_org_name hr_all_organization_units.name%TYPE;
161: l_project_number pa_projects_all.segment1%TYPE;
162: l_task_number pa_tasks.task_number%TYPE;

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

523: cse_util_pkg.write_log('Reversing the expenditures, for serialized items which are
524: being returned from Installed location');
525:
526: l_user_id := fnd_global.user_id ;
527: SELECT sysdate INTO l_sysdate FROM sys.dual ;
528: i := 0;
529: FOR csi_txn_rec IN csi_txn_cur
530: LOOP
531: i := 0 ;

Line 586: FROM DUAL;

582: LOOP
583:
584: SELECT csi_pa_interface_s.NEXTVAL
585: INTO l_ref_suffix
586: FROM DUAL;
587: l_txn_processed := TRUE ;
588:
589: OPEN c_Business_Group_cur( exp_rec.org_id ) ;
590: FETCH c_Business_Group_cur INTO l_Business_Group_rec;