APPS.CSE_COST_COLLECTOR dependencies on DUAL

Line 145: FROM sys.dual;

141: AND oap.acct_period_id = l_acct_period_id;
142:
143: CURSOR c_costing IS
144: SELECT NVL(FND_PROFILE.VALUE('CSE_EIB_COSTING_USED'),'Y')
145: FROM sys.dual;
146:
147: l_org_name hr_all_organization_units.name%TYPE;
148: l_project_number pa_projects_all.segment1%TYPE;
149: l_task_number pa_tasks.task_number%TYPE;

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

510: cse_util_pkg.write_log('Reversing the expenditures, for serialized items which are
511: being returned from Installed location');
512:
513: l_user_id := fnd_global.user_id ;
514: SELECT sysdate INTO l_sysdate FROM sys.dual ;
515: i := 0;
516: FOR csi_txn_rec IN csi_txn_cur
517: LOOP
518: i := 0 ;

Line 573: FROM DUAL;

569: LOOP
570:
571: SELECT csi_pa_interface_s.NEXTVAL
572: INTO l_ref_suffix
573: FROM DUAL;
574: l_txn_processed := TRUE ;
575:
576: OPEN c_Business_Group_cur( exp_rec.org_id ) ;
577: FETCH c_Business_Group_cur INTO l_Business_Group_rec;