APPS.CSE_ASSET_WIP_PKG dependencies on DUAL

Line 88: SELECT TRUNC(SYSDATE) INTO l_sysdate FROM DUAL ;

84:
85: BEGIN
86: cse_util_pkg.write_log('Begin update_comp_assets for top instance :'
87: || p_top_instance_id);
88: SELECT TRUNC(SYSDATE) INTO l_sysdate FROM DUAL ;
89: ---get all the immediate children of p_top_instance_id
90: l_relationship_query_rec.object_id := p_top_instance_id ;
91: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF' ;
92:

Line 267: SELECT SYSDATE INTO l_sysdate FROM DUAL ;

263: l_mass_add_rec.asset_category_id := fa_book_rec.asset_category_id ;
264: l_mass_add_rec.asset_key_ccid := fa_book_rec.asset_key_ccid ;
265: END LOOP ;
266:
267: SELECT SYSDATE INTO l_sysdate FROM DUAL ;
268:
269: l_mass_add_rec.payables_cost := p_cost_to_adjust ;
270: l_mass_add_rec.fixed_assets_cost := p_cost_to_adjust ;
271: l_mass_add_rec.payables_units := p_unit_to_adjust ;